Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time Formats
Hi,
I need to know how to change a value into a time format. eg. i want to change "2.5" into "02:30:00" (hh:mm:ss) is there a funtion in excel? Or if i have the values like "150:00", how can i convert it to "02:30:00"? Thanx in advance.. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time Formats
If I understand your question correctly the following formula should
work if the hours and fraction of hours are in cell A1: =INT(A1/24)+TIME(INT(A1),MOD(A1,INT(A1))*60,0) Set the format of the cell that contains this formula to [h]:mm:ss |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time Formats
=2.5/24 and format the result cell like time!
"150:00" looks like a real XL time format [m]:ss Re-format it like h:mm:ss Regards, Stefi €˛rj€¯ ezt Ć*rta: Hi, I need to know how to change a value into a time format. eg. i want to change "2.5" into "02:30:00" (hh:mm:ss) is there a funtion in excel? Or if i have the values like "150:00", how can i convert it to "02:30:00"? Thanx in advance.. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time Formats
thanx :)
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time sheets | Excel Worksheet Functions | |||
time sheet to calculate 2 different columns | Excel Worksheet Functions | |||
How to calculate Date & Time differences | Excel Worksheet Functions | |||
Time and motion chart | Charts and Charting in Excel | |||
Time Sheet Calculation Help Needed! | Excel Worksheet Functions |