How do I subtract time?

[Guest]

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.

 

[Domenic]

Try...

=(B1-A1+(B1<A1))*24

Hope this helps!

 

[Domenic]

Try...

=(B1-A1+(B1<A1))*24

Hope this helps!

 

[Guest]

Try:

=MOD((B1-A1),1)*24

Try...

=(B1-A1+(B1<A1))*24

Hope this helps!

 

[Guest]

Try:

=MOD((B1-A1),1)*24

Try...

=(B1-A1+(B1<A1))*24

Hope this helps!

 

[Guest]

Thanks, both work. =D

Try:

=MOD((B1-A1),1)*24

 

[Guest]

Thanks, both work. =D

Try:

=MOD((B1-A1),1)*24