billandrew
Well-known Member
- Joined
- Mar 9, 2014
- Messages
- 743
Good afternoon all
My question is how would I enter time ( Hours:Min ) and calculate the total.
My question is how would I enter time ( Hours:Min ) and calculate the total.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Time
- Thread starter billandrew
- Start date
xenou
MrExcel MVP
- Joined
- Mar 2, 2007
- Messages
- 16,836
- Office Version
- 2019
- Platform
- Windows
I suppose you can also store values as integer data. if the user enters, 15, 30, 45 or 60 then at the end you just sum up and divide by 60 and that is total time in hours. You take the remainder and multiply by 60 to get the minutes, i.e., 3.3333 hours is 3 hours and (.3333 * 60) = 20 minutes.
This kind of data entry is error prone since someone might enter .5 instead of 30 for half an hour (.5 hours instead of 30 minutes).
Normally, it's best to have user select start time and end time. Just like you do with a time clock.
This kind of data entry is error prone since someone might enter .5 instead of 30 for half an hour (.5 hours instead of 30 minutes).
Normally, it's best to have user select start time and end time. Just like you do with a time clock.
Last edited:
Upvote
0
Excel Facts
Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result
