How do I subtract time?
Thanks, both work. =D
"Toppers" wrote:
Try:
=MOD((B1-A1),1)*24
"Domenic" wrote:
Try...
=(B1-A1+(B1<A1))*24
Hope this helps!
In article ,
Fletch74 wrote:
I read that you can do (B1-A1)*24 but for the values where A is in PM and B
is in AM this returns a negative hour much larger than what it should be.
Any recommendations? Thanks.
|