Timesheet in Excel PLEASE HELP MEEEEE
Posted by ~*~*Louise*~*~* on February 11, 2002 3:24 AM
hello, i'm creating a timesheet for a school project i'm doing, but i've got a big problem.the manger enters the number of hours to be worked that month (say,180) and i subtract the hours worked by the employee by that number to get 'hours remaining'. but '180' is formatted as a number and the start,finish and monthly total amounts are formatted as times. so the i am not getting the right answer. eg if an employee has worked 16hrs 42mins that month its formatted as 16:42 and when subtracted from 180 i'm getting 7:18. i'm really really stuck please help!!!