Previous Topic Next Topic

Time differentials

Closed
sillygoose2014 Posts 9 Registration date Monday December 8, 2014 Status Member Last seen January 9, 2015 - Jan 9, 2015 at 10:12 AM
 RayH - Jan 12, 2015 at 11:26 AM
HELP!!!

I have 4 columns and need to figure out the hour differentials

Column A has a Date (1/3/15)
Column B has a Time (9:00am)

then Column F has a date (1/4/15)
and Column G has a time (2:00pm)

I need a way to write a formula that can tell me the number of hours in between those times.

Thanks in advance
Related:

3 responses

Answer 1 / 3
Blocked Profile
Jan 9, 2015 at 10:20 AM
Try this:

http://office.microsoft.com/en-gb/excel-help/calculate-the-difference-between-two-times-HP003056108.aspx
0
Answer 2 / 3
sillygoose2014 Posts 9 Registration date Monday December 8, 2014 Status Member Last seen January 9, 2015
Jan 9, 2015 at 10:45 AM
That won't work for me as i have seperate date and time columns. Unless I am looking at it wrong.
0
Blocked Profile
Jan 9, 2015 at 10:46 AM
Change be reference to reference the correct cells
0
sillygoose2014 Posts 9 Registration date Monday December 8, 2014 Status Member Last seen January 9, 2015
Jan 9, 2015 at 10:54 AM
I am confused, can you give me an example of what you are saying?
0
Answer 3 / 3
RayH
Jan 12, 2015 at 11:26 AM
=((F2+G2)-(A2+B2))*24

Answer is 29 hours.
0

Similar discussions

The system time is invalid
LeonardPromise -
Anonymous User -

5 responses
Keyboard wont type any letter twice
zsal5718 -
manoj -

23 responses
Facebook
Kasonde -
ElenaKM -

1 response