Hi
I have 2 cells. A1 is formatted as hh:mm[/color green] and contains the value 44:37[/color green] and A2 is formatted as dd:hh:mm[/color green] and the formula
, where the "8" represents that there are 8 hours in a working day.
The resulting value in A2 is 05:13:51[/color green] when I'm expecting it to be 05:04:37[/color green] (that's 5 days 4 hours and 37 minutes).
Seems that the # of days is correct, but I haven't a clue how to get the hours and minutes correct.
In another cell formated to GENERAL, I tried this formula
, which returns the correct number of days (5). I'm thinking that I could possibly do something with the MINUTES() function on the minute value of A1 to display the remaining fractional minutes but can't figure out how to reduce it by the minutes represented by the DAYS.
HELP!
Jim DeGeorge (MS Access Programmer)
I have 2 cells. A1 is formatted as hh:mm[/color green] and contains the value 44:37[/color green] and A2 is formatted as dd:hh:mm[/color green] and the formula
Code:
=(a1)*24/8
The resulting value in A2 is 05:13:51[/color green] when I'm expecting it to be 05:04:37[/color green] (that's 5 days 4 hours and 37 minutes).
Seems that the # of days is correct, but I haven't a clue how to get the hours and minutes correct.
In another cell formated to GENERAL, I tried this formula
Code:
=CONCATENATE(HOUR(A1/8)
HELP!
Jim DeGeorge (MS Access Programmer)