Time: convert 1.25 to 1.15 (one hour, fifteen minutes)

  • Thread starter Thread starter Stephen Simons
  • Start date Start date
S

Stephen Simons

I have a sheet where I have time calculations that show quarters, halves and three-quarters of the hours as .25, .50 and
..75.

How can I get them to display as 15, 30 and 45 - the number of minutes they denote.

Example

A1 contains 97.25 - I would like it to display as 97.15

Any help appreciated

TIA

Steve
 
Hi
put the following in B1
=A1/24
and format this cell with the custom format [hh]:mm

--
Regards
Frank Kabel
Frankfurt, Germany
Stephen Simons said:
I have a sheet where I have time calculations that show quarters,
Click to expand...
halves and three-quarters of the hours as .25, .50 and
 
If you don't want time, but just a decimal number of minutes, use

=A1*60

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Frank Kabel said:
Hi
put the following in B1
=A1/24
and format this cell with the custom format [hh]:mm

--
Regards
Frank Kabel
Frankfurt, Germany
Stephen Simons said:
I have a sheet where I have time calculations that show quarters,
Click to expand...
halves and three-quarters of the hours as .25, .50 and
.75.

How can I get them to display as 15, 30 and 45 - the number of minutes they denote.

Example

A1 contains 97.25 - I would like it to display as 97.15

Any help appreciated

TIA

Steve
Click to expand...
Click to expand...
 
Hi Stephen!

To do what you have asked for:

=INT(A1)+MOD(A1,1)*60/100

--
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.
Stephen Simons said:
I have a sheet where I have time calculations that show quarters,
Click to expand...
halves and three-quarters of the hours as .25, .50 and
 
Hi Stephen!

Always pleased to help. I'm not so sure that you shouldn't be using a
time format but I'm sure you have your reasons.

--
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.
Stephen Simons said:
Thanks Norman, that's right on the money!

Cheers mate

Steve
Click to expand...
 
Back
Top