ExcelBanter - Add 1 hour to data

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Add 1 hour to data (https://www.excelbanter.com/new-users-excel/240834-add-1-hour-data.html)

Israel

Add 1 hour to data

I have data 1 tru 200 with time "12:01:04". How can I add a hour to read
"1:01:04"
so when they move the clock in March '10 I will have the correct data.

Thank you
--
smile

Max

Add 1 hour to data

Try in B1: =A1+"1:00:00"
Copy down

Success? hit the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"israel" wrote:
I have data 1 tru 200 with time "12:01:04". How can I add a hour to read
"1:01:04"
so when they move the clock in March '10 I will have the correct data.

All times are GMT +1. The time now is 02:30 AM.