Time between dates

[Nath]

Hi,

Could you please tell me how I can work out the time
between these 2 date and times within excel?

03/06/2003 11:26:53
05/06/03 11:56:18

Many thanks for your time and help? (in advance)
Regards
Nathan

 

[J.E. McGimpsey]

Hi,

Could you please tell me how I can work out the time
between these 2 date and times within excel?

03/06/2003 11:26:53
05/06/03 11:56:18

XL stores dates as integer offsets from a base date (1/1/1904 by
default for MacXL) and times as fractional days (e.g., 3:00 =
0.125), so your stored values (which you can verify by formatting
the cells as General) are:

A1: 03/06/2003 11:26:53 ===> 36224.477
A2: 05/06/03 11:56:18 ===> 36285.49743

So to get the difference, just subtract:

A3: =A2 - A1 ===> 61.02042824

however, XL, in trying to be helpful, by default formats A3 as a
date and time:

03/02/1904 00:29

To see just time, format A3 with

Format/Cells/Number/Custom [hh]:mm:ss

(the brackets tell XL not to roll over the time at 24 hours) to
return:

1464:29:25

For more, see

http://www.cpearson.com/excel/datetime.htm#AddingTimes