Decimal numbers to time format.

[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

 

[Ron Rosenfeld]

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

=TIME(,A1,B1)

or

=A1/1440+B1/86400

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


--ron

 

[Lee Grant]

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

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

=TIME(,A1,B1)

or

=A1/1440+B1/86400

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


--ron

 

[Ron Rosenfeld]

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

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,

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

 

[Ron Rosenfeld]

there has been lots of slapping of
foreheads!!

Hmmm, lots of people, or one person with multiple foreheads? )
--ron

 

[Lee Grant]

I'm so dazed that I cannot tell - but I believe I assaulted myself
officer!!!