| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting from 12-hour to 24-hour format | Excel Worksheet Functions | |||
| Figure out 24 hour staffing data | New Users to Excel | |||
| convert decimal numbers to a fraction of an hour for payroll hour | Excel Worksheet Functions | |||
| Average dynamic data cells over a one hour period? | Excel Discussion (Misc queries) | |||
| How can I round an hour to the nearest 1/4 hour? | Excel Worksheet Functions | |||
Linear Mode
