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...


--
heathcliff
------------------------------------------------------------------------
heathcliff's Profile: http://www.excelforum.com/member.php...o&userid=24305
View this thread: http://www.excelforum.com/showthread...hreadid=379131

Your formula is correct.

You need to change the format

Format/Cells/Number

Choose Custom and select [h]:mm:ss

HTH

PC
"heathcliff" wrote
in message ...

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...


--
heathcliff
------------------------------------------------------------------------
heathcliff's Profile:
http://www.excelforum.com/member.php...o&userid=24305
View this thread: http://www.excelforum.com/showthread...hreadid=379131

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.

"PC" wrote:

Your formula is correct.

You need to change the format

Format/Cells/Number

Choose Custom and select [h]:mm:ss

HTH

PC
"heathcliff" wrote
in message ...

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...


--
heathcliff
------------------------------------------------------------------------
heathcliff's Profile:
http://www.excelforum.com/member.php...o&userid=24305
View this thread: http://www.excelforum.com/showthread...hreadid=379131

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"

"steve" wrote:

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.

"PC" wrote:

Your formula is correct.

You need to change the format

Format/Cells/Number

Choose Custom and select [h]:mm:ss

HTH

PC
"heathcliff" wrote
in message ...

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...


--
heathcliff
------------------------------------------------------------------------
heathcliff's Profile:
http://www.excelforum.com/member.php...o&userid=24305
View this thread: http://www.excelforum.com/showthread...hreadid=379131