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.
"Robin CSM002" wrote:
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,
|