Dates and times are stored in excel as a number, starting at 1/1/1900 as
) and incrementing by 1 each day.

Therefore an hour is = 1/24 or 0.041666667 of a day.

Today 5/1/2004 is 37991.


As time is a number you can simply adda nd subtract them as for any
other number.

Please note however that when Excel dispays a number, it assumes by
defult that the time is to be showing as a portion of 24 hours. So 32
hours(or 1.333333333 as a numebr) is displayed as 8:00 not 32:00.

To display the time in hours for periods greater than 24, amend the
cell custom format to read [h]:mm. ( the usual cell format is h:mm).
The [] instruct eexel to show the full hours.

Hopefully that can get you started with times.


---
Message posted from http://www.ExcelForum.com/