I experimented with 2/4/2007 3:00 am and 2/5/2007 7:45 pm and I got 16.75.

I also experimented with 2/4/2007 3:00 am and 2/7/2007 7:45 pm and I got 64.75.

Sounds about right?

See if this helps. http://www.cpearson.com/excel/datearith.htm Scroll down.

Do you have date and time in one cell or date in one cell and time in a different cell?

Epinn

"goldenrod59" wrote in message ...
I am needing to calculate the hours (with decimal portion) between two times
spanning two or more dates

e.g. the time between
2/4/2007 3:00 am 2/5/2007 7:45 pm

and have it displayed as a decimal portion of a 24 hour day

I have tried several formulas - no dice....


Thanks in advance for any help