| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
convert decimal to time
i want to know how to change the decimal to time format.
eg: when i enter the time as 9.30 i want that to be changed as 9:30 and also when i enter the time as 1.38 to be changed as 13:38 Thnak you |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
convert decimal to time
=time(INT(A1),MOD(A1,1)*100,0)
-- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "ganga" wrote in message ... i want to know how to change the decimal to time format. eg: when i enter the time as 9.30 i want that to be changed as 9:30 and also when i enter the time as 1.38 to be changed as 13:38 Thnak you |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
convert decimal to time
Hi
In order to deal with the second part of your request, you would need to modify Bob's formula with something like =TIME(INT(A1)+12*(INT(A1)<8),MOD(A1,1)*100,0) Any times which are less than 8, would have 12 hours added to make them PM instead of AM. Change the 8 to whatever value suits your purpose. -- Regards Roger Govier "Bob Phillips" wrote in message ... =time(INT(A1),MOD(A1,1)*100,0) -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "ganga" wrote in message ... i want to know how to change the decimal to time format. eg: when i enter the time as 9.30 i want that to be changed as 9:30 and also when i enter the time as 1.38 to be changed as 13:38 Thnak you |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
convert decimal to time
Thank you very match....
"Roger Govier" wrote: Hi In order to deal with the second part of your request, you would need to modify Bob's formula with something like =TIME(INT(A1)+12*(INT(A1)<8),MOD(A1,1)*100,0) Any times which are less than 8, would have 12 hours added to make them PM instead of AM. Change the 8 to whatever value suits your purpose. -- Regards Roger Govier "Bob Phillips" wrote in message ... =time(INT(A1),MOD(A1,1)*100,0) -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "ganga" wrote in message ... i want to know how to change the decimal to time format. eg: when i enter the time as 9.30 i want that to be changed as 9:30 and also when i enter the time as 1.38 to be changed as 13:38 Thnak you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert time into decimal with max function | Excel Discussion (Misc queries) | |||
| convert time into decimal with max function | Excel Discussion (Misc queries) | |||
| How to convert time to decimal | New Users to Excel | |||
| How do I convert time (38:30) to decimal (38.5) format? | Excel Worksheet Functions | |||
| convert decimal number to time : convert 1,59 (minutes, dec) to m | Excel Discussion (Misc queries) | |||
Hybrid Mode
