Hi,
I'm looking for a formula that will convert the number of hours into a breakdown of total days/hours/minutes in the table below. A typical shift is 7.5 hours (minus a 30 minute lunch) which is the equivalent of 1 day.
Cell A2 is where you key in your value.
Cells B2 to D2 display the results and cell E2 displays the message.
https://docs.google.com/spreadsheets...e7k/edit#gid=0
If you key in a value of 7.5, the respective cells should tell you it is 1 day (and 0 hours/minutes)
And if you key in 9 (someone worked an extra hour and half), the formula should display 1 day / 1 hour / 30 minutes.
Is this possible?
Bookmarks