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

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?