Forum Discussion
Time values
Craftybilda In B41, you see 02:45, being 2 hours and 45 minutes. But dates and times in Excel are in fact numbers (a full day is being 1, and for instance 12 hours equals 0.5 etc.) In this particular case, the underlying value is 0.114583333333333. Your formula in B42 creates a time value of 0 hours, 0 minutes (the leftmost number) and 33 seconds (the two rightmost numbers). What exactly do you want to show in B42 and B43? In case you want to "transform" 02:45 to decimal hours (i.e. 2.75), you can multiply the B42 by 24 and format the cell as a number.
At present your 'Total hours of palletising' shows a time duration of 02:45 but the value that gives rise to the display is actually 0.114583333 as a part of a day. I don't think you really need to convert to hours at this stage but, if you wish to, simply multiply B41 by 12.
If you do not convert from days to hours at this stage, your result will be measured in Pallets/Day. Converting the figures at that stage requires division by 24 to give Pallets/Hour.
Hopefully, this will simplify your intended calculation.