View Single Post
  #3   Report Post  
Zyzzx
 
Posts: n/a
Default 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