calculating time
XL stores times as fractional days, so multiply by 24 hours per day to
get hours:
=(B1-A1) * 24
In article <779ad662a28a3@uwe,
"Emerogork via OfficeKB.com" <u36894@uwe wrote:
7:00am int A1, 3:00pm in B1. When I (B1 - A1) I get 0.33 but I want 8.
Thoughts?
|