Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating uniform time format from multiple formats
I have received time punch data from client in multiple formats. I want to
create uniform time formats so I can conduct various calculations. I would like initial format to be h:mm:ss AM/PM. I will alter format thereafter as needed for calculations. Some punch data is in General format (examples, 1:54:00 PM and 10.06) & some are in Custom/h:mm (example, 12:30). Added issue is if I change the Custom/h:mm entries to h:mm:ss AM/PM, any entry that is 1:00 or after will change to 1:00 AM when it should be 1:00 PM. I am using Excel 2003. Any help from the Discussion Group will be most appreciated. Thank you! -- heyredone |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002: How to make the date format uniform ? | Excel Discussion (Misc queries) | |||
format cell with multiple formats for telephone numbers | Excel Discussion (Misc queries) | |||
Creating Multiple Graphs at a Time | Charts and Charting in Excel | |||
fast way creating multiple worksheets with same format in excel? | Excel Discussion (Misc queries) | |||
Multiple Date/Time Formats | Excel Worksheet Functions |