Minutes not hours please

  • Thread starter Thread starter ploboo
  • Start date Start date
P

ploboo

I want Excel to recognize 4:30 as 4 min & 30 secs for
other calculations. I've tried everything I can, but
Excel only recognizes it as 4 hours 30 mins. I know there
must be a simple way to fix this. Or will it only ever
recognize hh:mm:ss?

Thanks in advance for any help.
 
Hi Ploboo!

In other calculations why not just divide your 4:30 by 60

A1: 4:30
B1: =A1/60
Returns 00:04:30

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Why not just divide by 60 in your calculations?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
I want Excel to recognize 4:30 as 4 min & 30 secs for
other calculations. I've tried everything I can, but
Excel only recognizes it as 4 hours 30 mins. I know there
must be a simple way to fix this. Or will it only ever
recognize hh:mm:ss?

Thanks in advance for any help.
Click to expand...

Enter it as 4:30.0 or as 0:4:60


--ron
 
Back
Top