Thread: convert hours format to decimal or minutes (exp. 1:15:00 = 75 min.
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default convert hours format to decimal or minutes (exp. 1:15:00 = 75 min.
Alternatively

=(A1-A2)*24*60

Mike

"hard working andy w" wrote:

How do I copy and past a help example to a blank spreadsheet pertaining to
the above subject?

I can subtract an end time from a begin time to get hours and minutes
(1:15:00 or 75 minutes).

How do I convert 1:15:00 to 75 minutes?
Reply With QuoteReply With Quote