I am on flexi time and I want to calculate the number of flexi hours I have at the end of the week so I can take them hours off work the next week.
I have to work 7 hrs 24 mins every day and I work 5 days a week. What is the formular for calcating my hours
For examplem. Flexi hours = total hours worked - total standard hours (7hrs 24 mins per day)
But how would I put this into MS excel so that it automatically calculated my hours
I have to work 7 hrs 24 mins every day and I work 5 days a week. What is the formular for calcating my hours
For examplem. Flexi hours = total hours worked - total standard hours (7hrs 24 mins per day)
But how would I put this into MS excel so that it automatically calculated my hours
-
Enter your start time (ie 9 am) in A1
Enter your end time (ie 6 pm) in B1
In C1: =IF(B1-A1>0, B1-A1, 1+B1-A1)
If you enter 9 am and 6 pm in A1 and B1 respectively, C1 will show 9:00 (for 9 hours)
Enteriing 8:15 am for the start, with 6 pm end time, will show 9:45.
You don't have to change everything to minutes or seconds.
Enter your end time (ie 6 pm) in B1
In C1: =IF(B1-A1>0, B1-A1, 1+B1-A1)
If you enter 9 am and 6 pm in A1 and B1 respectively, C1 will show 9:00 (for 9 hours)
Enteriing 8:15 am for the start, with 6 pm end time, will show 9:45.
You don't have to change everything to minutes or seconds.
-
The only way you can do it is to change everything to minutes so the formula would be Minutes worked - 444 (minutes) OR by decimals of an hour so Hours worked - 7.4(hours)