Excel Time Conversion 1

[JJOHNS]

I have times in decimals. I want Excel to return it in hh:mm:ss format. So, if I put 7.50 in cell A1, then B1 should show 7:30:00

Does anyone know how to do this?

 

[SkipVought]

Why do Dates and Times seem to be so much trouble? faq68-5827

7.50 in Date/Time is the 7th day after 12/31/1899 at .5*24 of a day which is 12:00 PM



Skip,
[sub]
[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL![/sub]

 

[dhulbert]

JJOHNS

Use =A1/24 in cell B1 then format as a time and you get 07:30



I love deadlines. I like the whooshing sound they make as they fly by
Douglas Adams
(1952-2001)

 

[JJOHNS]

Thanks dhulbert. Worked great.

SkipVoight, umm, huh?

 

[SkipVought]

Do you understand WHY that works?

Did you read the FAQ?

The fact is that you do NOT have Microsoft System consistant Time Values. you have numbers that represent HOURS that you need to convert to Microsoft System consistant Time Values.

Skip,
[sub]
[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL![/sub]

 

[SkipVought]

JJ,

Just suppose that the NEXT time, you had a column of MINUTES instead of HOURS, like 53.5 minutes.

How would you convert that value to display 0:53:30?

Skip,
[sub]
[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL![/sub]