View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Leo Rod Leo Rod is offline
external usenet poster
 
Posts: 21
Default convert hours format to decimal or minutes (exp. 1:15:00 = 75 min.

To convert it to a value:
=MINUTE(A1)+(HOUR(A1)*60)
where A1 is the time.

"hard working andy w" <hard working andy wrote
in message ...
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?