|
show elapsed time ?
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 |
| All times are GMT +1. The time now is 12:09 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com