Mehawitchi
asked on
How to Convert Number to Time value - Excel 2007
Hello experts,
I have a table in excel containing time but written as number (not time values)
For example 600 instead of 06:00
I need your help in developing a user function that would convert 600 to 06:00.
Please see attched sample sheet.
Thank you Convert-number-to-Time.xlsx
I have a table in excel containing time but written as number (not time values)
For example 600 instead of 06:00
I need your help in developing a user function that would convert 600 to 06:00.
Please see attched sample sheet.
Thank you Convert-number-to-Time.xlsx
A1:600
B1:
=IF(LEN(A1)=3;"0"&LEFT(A1; 1)&":"&RIG HT(A1;2);L EFT(A1)&": "&RIGHT(A1 ;2))
B1:
=IF(LEN(A1)=3;"0"&LEFT(A1;
ASKER
Hi viralypatel
Thanks for the suggested solution, but I've tried this already and didn't work. It gave me wrong dates and time.
Have you tried it yourself? Did it work?
Thanks for the suggested solution, but I've tried this already and didn't work. It gave me wrong dates and time.
Have you tried it yourself? Did it work?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Took me so long I didn't see all those posts!
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hey, I'm overwhelmed.
All solutions worked but my preference goes to StephenJR because in one step I have a time value
All solutions worked but my preference goes to StephenJR because in one step I have a time value
2. right click and select format cells
3. select time.