Subtracting AM from PM Times

[The Animal]

Hi
I have a spreadsheet in a warehouse situation to calculate times taken to pack items. Some times start Am and finish PM which gives me #### as displaying as a negative. Formula using is =(IF(V62>0,$E62-$D62,"")). Start and Finish Time are in *1:30:55 PM and formula cell is in hh:mm:ss
Any help would be great.
Thanks Stephen

 

[T. Valko]

Hi
I have a spreadsheet in a warehouse situation to calculate times taken to pack items. Some times start Am and finish PM which gives me #### as displaying as a negative. Formula using is =(IF(V62>0,$E62-$D62,"")). Start and Finish Time are in *1:30:55 PM and formula cell is in hh:mm:ss
Any help would be great.
Thanks Stephen

Try it like this...

A1 = 11:00 PM
B1 = 3:00 AM

=MOD(B1-A1,1)

 

[The Animal]

Thanks for your help have done as you suggested and works fine so how will my formula look with the >0 section that ignores the V62 cell.if zeroTied =(IF(V62>0,MOD$E62-$D62,"")) (plus a few other combinations) which ignores the V62 and forces E and D cells but does not seem to work.
Thanks

 

[Michael M]

try

=IF(V62>0,MOD($E62-$D62,1),"")

 

[The Animal]

Thanks Michael your a Champion.