Automatic computation of Hour and Minutes
Hi,
I would like to ask if there's a possibility that if I input values for hours and mins it will automatically be computed the "TOTAL" based on the equivalent of hours and mins for an 8-hour workday table.
Here's the sample:
I put 01:00 (1 hour) in Hours and 00:25 (25 minutes) in Minutes, the total should be
.125 (equivalent day for 1 hour) + .052 (equivalent day for 25 minutes) = 0.177