Decimal numbers to time format.

  • Thread starter Thread starter Lee Grant
  • Start date Start date
L

Lee Grant

Hi there,

I'm sure this is a simple one for you guys but I'm not having fun trying to
get to the bottom of it.

I have two cells:

A1 - contains 47 (formatted as 'number to two decimal places')
B1 - contains 12 (formatted as 'number to two decimal places')

I have other cells formatted for time as [hh]:mm:ss

How can I fill C1 with 00:47:12 (formatted as [hh]:mm:ss) - with the 47 and
12 being pulled from A1 & B1

Cheers

Lee
 
Hi there,

I'm sure this is a simple one for you guys but I'm not having fun trying to
get to the bottom of it.

I have two cells:

A1 - contains 47 (formatted as 'number to two decimal places')
B1 - contains 12 (formatted as 'number to two decimal places')

I have other cells formatted for time as [hh]:mm:ss

How can I fill C1 with 00:47:12 (formatted as [hh]:mm:ss) - with the 47 and
12 being pulled from A1 & B1

Cheers

Lee
Click to expand...

=TIME(,A1,B1)

or

=A1/1440+B1/86400

and format the cells as [hh]:mm:ss


--ron
 
One day I'm going to ask you something and you won't know the answer ;-)

I'd trawled the Excel help for a few hours on this one and now you've
pointed the solution out to me there has been lots of slapping of
foreheads!!

Many thanks again Ron,

Cheers

Lee

Ron Rosenfeld said:
Hi there,

I'm sure this is a simple one for you guys but I'm not having fun trying
to
get to the bottom of it.

I have two cells:

A1 - contains 47 (formatted as 'number to two decimal places')
B1 - contains 12 (formatted as 'number to two decimal places')

I have other cells formatted for time as [hh]:mm:ss

How can I fill C1 with 00:47:12 (formatted as [hh]:mm:ss) - with the 47
and
12 being pulled from A1 & B1

Cheers

Lee
Click to expand...

=TIME(,A1,B1)

or

=A1/1440+B1/86400

and format the cells as [hh]:mm:ss


--ron
Click to expand...
 
One day I'm going to ask you something and you won't know the answer ;-)
Click to expand...

Don't forget, I only respond to the questions to which I know the answer !!
I'd trawled the Excel help for a few hours on this one and now you've
pointed the solution out to me there has been lots of slapping of
foreheads!!

Many thanks again Ron,
Click to expand...

You're welcome. Glad to help.
--ron
 
Back
Top