MrExcel Publishing
Your One Stop for Excel Tips & Solutions

ADD HOURS


Posted by CHARLES LAGANA on September 21, 2001 11:44 AM

I HAVE A COLUMN WITH TIME DATA. I WANT TO CREATE ANOTER COLUMN THAT ADDS EITHER 1,2 OR 3 DEPENDING IF THE TIME IS WEST,MOUNTAIN OR CENTRAL (I WANT THIS TO BECOME E.S.T) NO MATTER WHAT I TRY IT DOES NOT ADD IT AND I DO NOT GET AN ERROR MESSAGE. THANKS FOR YOUR HELP. IE: REGARDING THE FIRE TRUCK I LIVE IN NYC NOT FAR FROM WTC AND I HAVE GIVEN ALREADY FOR BOTH POLICE AND FIRE DEPT ADDITIONNALY I HAVE BROUGHT FOOD, FLASHLIGHTS ETC.THAT IS A GOOD THING THAT YOU ARE DOING. THANKS AGAIN


Posted by IML on September 21, 2001 11:47 AM

With your time in A1 use
=A1+1/24 for one hour. Excel store time in fractions of days.

good luck