Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Converting Time
I get a file that displays time as 0515A. I need to convert it to 05:15 AM.
I use the mid function to retrieve the hour, minutes and A or P. I then rebuild the string as 05:15 AM and write it to a cell. Before writing it to a cell, I format the cell as "hh:mm AM/PM". When I look at the cell, I see 05:15 AM. However, the actual cell value is 05:15:00 AM. Is there a format or way to make the actual cell value as 05:15 AM instead of 05:15:00 AM? Thanks for the help...... -- JT |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Converting Time
Format as text as you are building a text string.
dm "JT" wrote: I get a file that displays time as 0515A. I need to convert it to 05:15 AM. I use the mid function to retrieve the hour, minutes and A or P. I then rebuild the string as 05:15 AM and write it to a cell. Before writing it to a cell, I format the cell as "hh:mm AM/PM". When I look at the cell, I see 05:15 AM. However, the actual cell value is 05:15:00 AM. Is there a format or way to make the actual cell value as 05:15 AM instead of 05:15:00 AM? Thanks for the help...... -- JT |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Converting Time
Format as text as you are building a text string.
....or leave it the way you have it now (as a date), but use the Text property of the Range object when building a text string in code (VBA); or use the TEXT function to format it the way you want when building a text string in a worksheet formula. -- Rick (MVP - Excel) |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Converting Time
Actually when you enter the time as 05:15 AM, for excel the actual
cell value will be 05:15:00 AM as excel assumes that second part is zero as you have not mentioned it. I believe, there is nothing wrong if excel shows seconds as zero. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting Standard Time to Military Time in Excel | Excel Discussion (Misc queries) | |||
formula for converting military time to standard time, etc | Excel Discussion (Misc queries) | |||
Converting date/time serial values to cumulative time totals... | Excel Discussion (Misc queries) | |||
Converting time formats into actual time(minutes) | Excel Discussion (Misc queries) | |||
Converting decimal time to standard time? | Excel Discussion (Misc queries) |