# 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.

Related:

## 3 responses

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
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.
Blocked Profile
Jan 9, 2015 at 10:46 AM
Change be reference to reference the correct cells
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?
=((F2+G2)-(A2+B2))*24