View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Max Max is offline
external usenet poster
 
Posts: 9,221
Default 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.