Jul 27 2020 10:32 AM
First time user of the community. Probably a very simple question but, how do I caculate the total hours when, in Cell #1 I have the start time (e.g. 8:00 am) and the other cell I have the end time (5 pm.)?
Jul 29 2020 03:47 PM
Jul 29 2020 04:19 PM
Thank you, I tried that and here is the result:
Time In | Breaks | Time Out | Hours |
8:00:00 AM | 0.50 | 6:00:00 PM | -0.42 |
It should total: 10 hrs??
Jul 29 2020 05:28 PM
@Northwest_Plumbing , change the number format to "hh" to get the time in hours.
Jul 29 2020 06:02 PM
Thank you Anthony. That helped to make it look better but, I still haven't found a formula to add the hours from start time to end time?
Jul 30 2020 02:47 AM
Operate with time as with any numbers. Actually in Excel days are equivalent of integer numbers where 1 is Jan 01, 1900 and time is decimal part of the number where 1 hour is equal to 1/24.
Just apply time format to the result and take into account time could not be negative.
Jul 30 2020 03:03 AM
even if the solution of the others are more elegant .. I send my small solution for quick processing :)
sry in advance for my additional intervention
If you have solved your problem with this solution, please mark it as the correct answer so that others can also get this information.
If this is not what you are looking for, please give us a quick feedback.
Nikolino
I know I don't know anything (Socrates)