Forum Discussion
Adding new rows
Hello everyone! I have an excel file with time and date stamps. The data has time stamps arranged from 6am to 6pm everyday for a whole year in 1 column. But we decide to make it 12 am to 12pm eve...
iammanny Since you only have to do this once, the easiest is probably to insert a column a temporary column as shown in the picture below.
Let's assume the time stamps (6am to 6pm with 10 minute intervals) are proper time values in column A, then you can add 0.25 to each of these time values. That will increase the times by 6 hours.
(Excel calculates time as a portion of 1 day containing 24 hours. Six hours thus equals 0.25 of one day.)
Now copy column B and paste as values to A. Remove column B and you are all set.