J
johnfli
I have a formula
=IF(LEN(TRIM(H2))>1,SUM(J2-H2),SUM(J2-I2))
That takes 2 times, subtracts them and the answer is the "Elapsed Time"
(This answer is in K2)
in L2, I want it to tell me how much time over 1 hour (in minutes).
For example, in Cell (J2) I could have 5:00
iin cell (H2) I could have 2:00
this would give me 3:00 in cell (K2)
now in this case, I would want (L2) to read 180
how do I do this??
=IF(LEN(TRIM(H2))>1,SUM(J2-H2),SUM(J2-I2))
That takes 2 times, subtracts them and the answer is the "Elapsed Time"
(This answer is in K2)
in L2, I want it to tell me how much time over 1 hour (in minutes).
For example, in Cell (J2) I could have 5:00
iin cell (H2) I could have 2:00
this would give me 3:00 in cell (K2)
now in this case, I would want (L2) to read 180
how do I do this??