Calculate hours and minutes between times when it goes past mi
"Teethless mama" wrote:
Another way...
=MOD(B1-A1,1)
"SC_Dave" wrote:
IE: Time starts at 7:00PM on one day and ends at 5:00AM the next morning.
When I do it the conventional way it calculate 14 hours when in fact its 10
hours. Any help would be greatly appreciated.
I spoke too fast, Why am I getting #VALUE!
|