Thread: convert hours format to decimal or minutes (exp. 1:15:00 = 75 min.
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein \(MVP - VB\) Rick Rothstein \(MVP - VB\) is offline
external usenet poster
  
Posts: 2,202
Default convert hours format to decimal or minutes (exp. 1:15:00 = 75 min.
I think Mike used A1*60*24 since it makes more sense than 1440 or 86400
with seconds

I mean, since we are working with time values if you convert 55000
seconds into Excel time values I think =55000/24/60/60 makes more sense
than =55000/86400

No, I understand that... I just meant that I would have used 1440 in the
formula and put an explanation in the text telling the OP where the number
came from. Sorry for not being more clear about that.

Rick

Reply With QuoteReply With Quote