Thread: Convert HH:MM to number as minutes only
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Max
 
Posts: n/a
Default Convert HH:MM to number as minutes only
"Blurb" wrote:
I am looking for a formula to changed formated cells as HH:MM to a whole
number of minutes only.
For example 07:20 change to 440. 440 being the number of minutes.

With source in A1, try in B1: =A1*24*60
Format B1 as general or number
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
Reply With QuoteReply With Quote