Posted: 4/16/2010 12:05:36 PM EDT
|
I need help finding a 1 week schedule program that will accommodate approx 10 people that will tally up the hours worked by each one per week
I have tried to do this in excel but can't get the hours to calculate in 60 minute increments. Does anyone have something like this that they would share with me? Thanks Eric |
|
Why are you recording time in 1 minute increments and dividing the numebr of numbers by 60 will get you the hours. If you want whole numbers then implement rounding. Perhaps i'm just not understanding your problem.
Anyway, I don't know of any good ones, but if you've got some money to spend I can build you something custom with whatever you need it to do. |
|
NO cash to spend and I have little exp. with excel. Was hoping for something simple. My boss wants the schedule printed off the computer now and when I have to key in the blocks that add up the daily hours I have to key in 7.5 for 7H. 30min and the final tally is in 1/100 of a min. instead of 1/60th of a min. resulting in someone having 39.75 hours / week. I want it to read 39.45 for 39 hours and 45 min.
Did that make any sense? |
|
excel, (or calc if you're linux based) should work for you. decimal hours worked times 60 will yield total minutes worked. int(decimal hours input) yields whole hours worked... then, (decimal hours - (int(decimal hours))) * 60 gives left over minutes. Is this what you're looking for? Edited for correct brackets/formula..sorry. |
|
Make separate columns for hours and minutes.
Say column A1 through A5 has the hour portion and column B1 through B5 has the minute portion. To get the total hours and minutes put the following formulas in place: At A6 put this formula: =SUM(A1:A5)+INT(SUM(B01:B05)/60) This gives you the hour portion At B6 put this formula: =SUM(B01:B05)-(INT(SUM(B01:B05)/60)*60) This gives you the minute portion. |