I need to calculate accrued vacation. For each hour worked an employee accrues 1 minute and 13 seconds of vacation. If an employee has worked 921 hours, how do I multiply 921 times 1:13 with the result in hours and minutes?
I need to calculate accrued vacation. For each hour worked an employee accrues 1 minute and 13 seconds of vacation. If an employee has worked 921 hours, how do I multiply 921 times 1:13 with the result in hours and minutes?
Last edited by bnhinton; 12-27-2013 at 12:48 PM.
Perhaps =A1*"00:01:13" and format as [h]:mm ? where A1 contains the hours worked?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks