Hi there! I need help with an error I am having with a timecard spreadsheet.
The current worksheet calculates employee hours to the minute. The problem that I am having is it will sum the total hours to i.e. 37.82. BUT there are only 60 minutes in an hour so instead of 37.82 it should be 38.22 (38 hours and 22 minutes.) Is this where I should use the ROUNDUP function or is there another formula that I should use. I am attaching the spreadsheet for help.
THANK YOU!
Bookmarks