View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Excel_seek_help
 
Posts: n/a
Default Convert 1934 minutes into 32Hour 14Minutes

Hi,

How can I convert the row total of 1934 minutes into 32 hours 14 minutes? I
used Time(0,0,0) and it came up with 8:14:00. I checked and found the system
had brought 1440 minutes to zero already because it's 24 hours.

Also, how can I round up seconds to minute?

Your reply is appreciated.