Hi all. Need help getting the elapsed time in percent of total time.
Start Time = Time Entered 1
End Time = Time Entered 2
Current Time = Now()
Elapsed Time = Current Time = Start Time
Total Time = End Time - Start Time
I tried to get percent time elapsed by dividing = Elapsed Time/Total Time but that didn't work.
I also tried converting to minutes, but that didn't work.
Any help would be appreciated
Welcome to the Forum saar!
"that didn't work" doesn't tell us enough. What did you expect to happen, and what actually happened? What were the actual values you were using for Start Time and End Time? Are you using Excel time values?
Please show actual Excel formulas and cell references rather than a description.
Your division formula, based only on what you described, should work, although it will give >100% if current time is past the end time.
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
Thank you for the feedback. lets try again.
Start Time = 09:45
End Time = 17:45
Total Time = End Time - Start Time = 08:00 (8 hrs)
Current Time = Now() = lets say 13:45 (from formula for current time)
Elapsed Time = Current Time - Start Time = 04:00 (4 hrs have elapsed)
Percent Time passed = Elapsed Time/Total Time = i would expect 50%, but i get some massive number in the millions.
Note, if i manually put in 13:45 as current time, i get the correct percent time passed. but when i use the current time formula = Now(), i get this weird result.
hope that clarifies.
I should have realized this from your first post. When you use the NOW() function, it includes date and time, not just time. Use
Formula:
Please Login or Register to view this content.
instead of
Formula:Please Login or Register to view this content.
to get just the time.
Thank you. You are my new King
You're welcome!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks