Problem converting Hours to Days, Hours, Minutes
Thank you all very much for your replies. Bruce nailed it with this simple
equation. I guess I just didn't understand how this simple formula worked.
Thanks again!
Z
"bpeltzer" wrote:
If these are proper times in Excel, you should be able to use its built-in
functions:
=DAY(G21) & " days, " & HOUR(G21) & " hours, " & MINUTE(G21) & " minutes"
--Bruce
|