Time Calculations Help
On Sep 3, 4:42*pm, "joeu2004" wrote:
Errata.... *I wrote:
=(TEXT(B1,"00\:00")-TEXT(A1,"00\:00"))*24
formatted as Number. *Of course, that returns 10.5, not 9.5, with the
example times of 1330 and 2300.
Brain fart! *The formula is right, and it returns 9.5, not 10.5.
LOL. No problem. I was making it too complicated for my own good.
Thanks to you, joeu2004, Ron Rosenfeld and Shell Shocked. DonW
|