What is the formular for calculating my hours
Favorites|Homepage
Subscriptions | sitemap
HOME > Mathematics > What is the formular for calculating my hours

What is the formular for calculating my hours

[From: ] [author: ] [Date: 11-07-19] [Hit: ]
with 6 pm end time, will show 9:45.You dont 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.......
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

-
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.

-
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)
1
keywords: my,is,calculating,for,hours,the,What,formular,What is the formular for calculating my hours
New
Hot
© 2008-2010 http://www.science-mathematics.com . Program by zplan cms. Theme by wukong .