hours:minutes ?

  • Thread starter Thread starter Randy Tingley
  • Start date Start date
R

Randy Tingley

To the Excel Wizards,

I have a cell formatted in hh:mm (hours:minutes), and I
was wondering if their is a way to pull out the hours only
to one cell and pull the minutes to another cell?

Thank you for sharing your vast knowledge.
Randy

--


**********************************************************************
Randy Tingley "Life is an Adventure,
Mary Anniballi not an ulcer giving experience"
(e-mail address removed)
**********************************************************************
 
One way:

If you want the results as integers:

A1: 12:34
A2: =HOUR(A1) ===> 12
A3: =MINUTE(A1) ===> 34

If instead you still want the results as times:

A2: =FLOOR(A1, "01:00") ===> 12:00
A3: =MOD(A1, "01:00") ===> 00:34

You may have to format the above to time format.
 
Back
Top