H
heyredone
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!
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!