How do I calculate duration between two dates and times in excel?

R

Robin CSM002

I need to calculate the difference in hours between two dates and times. For
example the difference in hours between 11:25 on 23/07/2004 and 18:00 on
06/08/2004? The dates and times have already been determined by the start and
end of a particular event. Thanks,
 
B

Barb R.

Let's say the 23/07/2004 date is in A1 and the 06/08/2004 date is in B1

C1 =(B1-A1)*24 gets time in hours. Ensure that C1 is formatted to say
NUMBER with 2 decimal places.
 
J

JE McGimpsey

One way:

=ROUND((A2-A1)*24,0)

where A1 has your start date/time and A2 has your end date/time. Since
XL stores times as fractional days, multiplying integral plus fractional
days by 24 gives hours.
 
Top