Trying to find minutes from times with no dates and the formula is working until the cell format is changed. Any ideas how to correct?
First Time = A1 (23:00)
Second Time =A2 (01:00)
=(A2-A1)+24 returns the correct result (2:00) when the cell is formatted as h:mm
However, I need it as minutes. When the cell is reformatted as [m] Total minutes, it returns 33240 instead of the expected 120 minutes. Any Ideas why?
The overall formula I am using is
=If(A1>A2,(A2-A1)+24,A2-A1)
First Time = A1 (23:00)
Second Time =A2 (01:00)
=(A2-A1)+24 returns the correct result (2:00) when the cell is formatted as h:mm
However, I need it as minutes. When the cell is reformatted as [m] Total minutes, it returns 33240 instead of the expected 120 minutes. Any Ideas why?
The overall formula I am using is
=If(A1>A2,(A2-A1)+24,A2-A1)