HELLLLLPPPPPP. Hi there can some one help me please. I work different hours each day of the week and I cant seam to find how to calculate these hours to ensure that I do 40 hours a week and show If if i do over the 40 hours Please bear with me and I will try to explain
A)CELL A1 40 (representing the hours) CELL A2 2400 Representing the minutes-these will change progressivly as i enter how much how much time i work daily.
CELL B2 Monday B3 Hours that I work B4 minutes Minutes that I have worked B5 total Hours in B3 Plus Minutes in B4.
IE:
B2 Monday B3 6 (hours) B4 45 (Minutes) B5 405 (Total Minuts Worked)
This will be done for the 7 days.At the end of the week I need to convert these total minuts back to hours firstly for a cross reference Secondly to print out for the company.
When I go to convert the 405,dividing by 60,in Cell B5 I keep geting 6.75.
Sorry If i could i would have explained it better.
Regards Tony
A)CELL A1 40 (representing the hours) CELL A2 2400 Representing the minutes-these will change progressivly as i enter how much how much time i work daily.
CELL B2 Monday B3 Hours that I work B4 minutes Minutes that I have worked B5 total Hours in B3 Plus Minutes in B4.
IE:
B2 Monday B3 6 (hours) B4 45 (Minutes) B5 405 (Total Minuts Worked)
This will be done for the 7 days.At the end of the week I need to convert these total minuts back to hours firstly for a cross reference Secondly to print out for the company.
When I go to convert the 405,dividing by 60,in Cell B5 I keep geting 6.75.
Sorry If i could i would have explained it better.
Regards Tony