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.
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.
- Many thanks indeed Riny,
I have solved the problem with your assistance. I simply had to reformat B41 (02:45) as text, then sum the these time values, and calculate the number of palates handled per hour. The main problem was to have the only exercise for the handlers to do was to enter the hours worked in handling the palates, the excel calculates the number of palates handled per hour automatically. Management can then look at methods of maximizing efficiency.
