Decimal numbers to time format.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lee Grant - 18 Dec 2007 12:21 GMT

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

Reply to this Message

Ron Rosenfeld - 18 Dec 2007 12:51 GMT

>Hi there,
>
[quoted text clipped - 14 lines]
>
>Lee

=TIME(,A1,B1)

or

=A1/1440+B1/86400

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

--ron

Reply to this Message

Lee Grant - 18 Dec 2007 13:50 GMT

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

> On Tue, 18 Dec 2007 12:21:54 -0000, "Lee Grant"
> <lee@inspirationcomputers.com>
[quoted text clipped - 30 lines]
>
> --ron

Reply to this Message

Ron Rosenfeld - 18 Dec 2007 14:11 GMT

>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

Reply to this Message

Ron Rosenfeld - 18 Dec 2007 14:12 GMT

> there has been lots of slapping of
>foreheads!!

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

Reply to this Message

Lee Grant - 19 Dec 2007 17:06 GMT

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

> On Tue, 18 Dec 2007 13:50:15 -0000, "Lee Grant"
> <lee@inspirationcomputers.com>
[quoted text clipped - 5 lines]
> Hmmm, lots of people, or one person with multiple foreheads? :-))
> --ron

Reply to this Message

Rate this thread: