Hi,
New at posting but have used the board for all my excel problems for a long time.
I currently have a timesheet that's been working great for my office which is set to calculate time to the nearest tenths but recently our accounting wants to calculate to the nearest 0.25 hour. I've read all the topics on this matter but I can't change the existing formulas correctly.
Column B= Time in
Column C= Lunch time out
Column E= Lunch time back
Column F= Time out
Column G= Total hours
Column H= Regular hours
Column I= Straight time
Column J= Overtime
Column k= Double time
Any help would be greatly appreciated..thanks!
New at posting but have used the board for all my excel problems for a long time.
I currently have a timesheet that's been working great for my office which is set to calculate time to the nearest tenths but recently our accounting wants to calculate to the nearest 0.25 hour. I've read all the topics on this matter but I can't change the existing formulas correctly.
Timesheet1.xls | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
B | C | D | E | F | G | H | I | J | K | L | M | N | |||
10 | 9:00 AM | 1:00 PM | 2:00 PM | 8:00 PM | 10.00 | 7.50 | 0.50 | 2.00 | |||||||
11 | 8:30 AM | 1:00 PM | 1:00 PM | 6:00 PM | 9.50 | 7.50 | 0.50 | 1.50 | |||||||
12 | 8:00 AM | 1:00 PM | 2:00 PM | 10:00 PM | 13.00 | 7.50 | 0.50 | 4.00 | 1.00 | ||||||
TimeSheet |
Column B= Time in
Column C= Lunch time out
Column E= Lunch time back
Column F= Time out
Column G= Total hours
Column H= Regular hours
Column I= Straight time
Column J= Overtime
Column k= Double time
Any help would be greatly appreciated..thanks!