Microsoft Office Forums - View Single Post - How to add time to cell values

Thread: How to add time to cell values

View Single Post

Old

12-14-2015, 09:19 PM

sdrawkcab

sdrawkcab is offline

sdrawkcab uses Windows 7 32bit

Windows 7 32bit sdrawkcab uses Office 2003

sdrawkcab uses Office 2003

Office 2003

Novice

Join Date: Dec 2015

Posts: 4

sdrawkcab is on a distinguished road

Default

A2 is start time
B2=A2+TIME(0,10,0)
C2=B2+TIME(0,15,0) and so on
Format affected cells as [h]:00

Last edited by sdrawkcab; 12-14-2015 at 09:24 PM. Reason: Forgetful

Reply With Quote