Convert Minutes to Hundredths
bribriflo
-
Vaucluse Posted messages 27336 Registration date Status Contributeur Last intervention -
Vaucluse Posted messages 27336 Registration date Status Contributeur Last intervention -
Hello,
Can someone tell me how to convert minutes into hundredths of an hour? Let me explain:
2:45:00 (two hours and forty-five minutes) I would like it translated into 2:75 (two hours and seventy-five hundredths)
I may not be very clear and perhaps I'm complicating things, but I need it to deduct the work time done month by month. We need to work 45 weeks a year. For a full-time schedule, that's 45 weeks at 35 hours.
So I made a table that looks at our monthly schedules to check the time worked and that should deduct the time left to do each month. Here, 1,575 hours to be completed - done in September for example, 151 hours 45 minutes or 151.75. The calculation should be automatic and yield 1575 - 151.75 = 1423.25 hours to be completed.
Can someone tell me how to convert minutes into hundredths of an hour? Let me explain:
2:45:00 (two hours and forty-five minutes) I would like it translated into 2:75 (two hours and seventy-five hundredths)
I may not be very clear and perhaps I'm complicating things, but I need it to deduct the work time done month by month. We need to work 45 weeks a year. For a full-time schedule, that's 45 weeks at 35 hours.
So I made a table that looks at our monthly schedules to check the time worked and that should deduct the time left to do each month. Here, 1,575 hours to be completed - done in September for example, 151 hours 45 minutes or 151.75. The calculation should be automatic and yield 1575 - 151.75 = 1423.25 hours to be completed.
