Time over 1 hour

  • Thread starter Thread starter johnfli
  • Start date Start date
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))

??? Lost me. However, in L2,

=K2*1440

, ie: 60 mins * 24 hours. Format L2 as General.

Rgds,
Andy
 
| =IF(LEN(TRIM(H2))>1,SUM(J2-H2),SUM(J2-I2))

Hi John,

I don't get the purpose of all the gymnastics on this. Why not just use
this:

=IF(H2>1/24,J2-H2,J2-I2)

Then use Andy's formula in L2:

=K2*1440

| in L2, I want it to tell me how much time over 1 hour (in minutes)

Andy's post will give you the time in minutes. If you really want "how much
time over 1 hour," then you'll need to subtract an hour (remember to format
as general:

=K2*1440-60

tim
 
Back
Top