show elapsed time ?

[heathcliff]

what formula do i have to use to get excel to calculate elapsed time i
i have the start and end times? i'm guessing end_time - start_time
duration, but i can't figure out how to write the formula to calculat
the elapsed time. i tried b1-a1 but that didn't work..

 

[PC]

Your formula is correct.

You need to change the format

Format/Cells/Number

Choose Custom and select [h]:mm:ss

HTH

PC

 

[Guest]

I have a further question: I want to use elapsed times in a conditional.
For example, if 25 minutes have elapsed, I want an output of 3, if between 25
and 30, an output of 4, if above 30, an output of 5. I am currently trying
to do this with nested IF's, but with no luck. Any ideas how I can compare
elapsed times, or convert them to some sort of decimal that I could use in a
comparison?

Thanks.

Your formula is correct.

You need to change the format

Format/Cells/Number

Choose Custom and select [h]:mm:ss

HTH

PC

 

[Guest]

time is maintained as a one for one day
thus one minute is equivelant to 1/(60*24) 0.000694444

if a1 and a2 are you two times

try
=if(a1-a2<25/(60*24),3,if(a1-a2<30/(60*24),4,5))
you may have to play with < and <= to get the final "what you want"

I have a further question: I want to use elapsed times in a conditional.
For example, if 25 minutes have elapsed, I want an output of 3, if between 25
and 30, an output of 4, if above 30, an output of 5. I am currently trying
to do this with nested IF's, but with no luck. Any ideas how I can compare
elapsed times, or convert them to some sort of decimal that I could use in a
comparison?

Thanks.

Your formula is correct.

You need to change the format

Format/Cells/Number

Choose Custom and select [h]:mm:ss

HTH

PC

what formula do i have to use to get excel to calculate elapsed time if
i have the start and end times? i'm guessing end_time - start_time =
duration, but i can't figure out how to write the formula to calculate
the elapsed time. i tried b1-a1 but that didn't work...