Calculating time

[Colonel Blip]

I have dates and times in a ss in a single column using the format of
mo/da/yr. hh.mm. I would like to be able to find the difference between
these entries in hours (or hours and minutes). Is this possible or do I need
to have separate columns for time and date?

A B
1 3/11/04 19:00
2 3/12/04 7:30
3 3/15/04 12:30

 

[Ron de Bruin]

Hi Colonel

Check out this page from Chip Pearson
http://www.cpearson.com/excel/datearith.htm

 

[DDM]

Colonel, just subtract the earlier date/time from the later one and custom
format the cell holding the result as follows: d:hh:mm for days, hours, and
minutes, or [h]:mm for hours and minutes.

DDM
"DDM's Microsoft Office Tips and Tricks"
http://ddmara.tripod.com

 

[Colonel Blip]

Got it. Thanks to all for the help.

Colonel, just subtract the earlier date/time from the later one and
custom format the cell holding the result as follows: d:hh:mm for
days, hours, and minutes, or [h]:mm for hours and minutes.

DDM
"DDM's Microsoft Office Tips and Tricks"
http://ddmara.tripod.com

I have dates and times in a ss in a single column using the format
of mo/da/yr. hh.mm. I would like to be able to find the difference
between these entries in hours (or hours and minutes). Is this
possible or do I need to have separate columns for time and date?

A B
1 3/11/04 19:00
2 3/12/04 7:30
3 3/15/04 12:30

--
Colonel Blip
(e-mail address removed)
Remove "nospam" when replying.
__________________________________