Update time fields with AM/PM according to total hours column.
We have a system that exports time-sheets to CSV file, and from there it goes further...
There is also another column that includes the total hours.
Since users enter some times the timing with AM/PM and sometimes not.
We would like to have a function that will do the following.
Open that CSV file, update the time fields with AM/PM according to the total hours.
Would prefer either a VB Script or a VBA function.
PS. The Total hours column can be off with an hour or so (which is the lunch break).