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