How to add time to cell values

		Microsoft Office Forums > Microsoft Excel > Excel
How to add time to cell values

12-14-2015, 09:19 PM

sdrawkcab

Windows 7 32bit How to add time to cell values

Office 2003

Novice

Join Date: Dec 2015

Posts: 4

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Convert large seconds values to a time format fails with #Value	Sekerob	Excel	3	07-18-2015 01:56 PM
Challenge summing time (mm:ss) values?	Mr Davo	Excel	3	12-17-2014 10:41 AM
Convert non-cell input to cell values	TBD	Excel	3	06-09-2014 06:14 AM
MATCH function and time values	hanvyj	Excel	2	05-29-2013 12:12 PM
Formatting Merged Time Values Between Excel & Word	JennEx	Mail Merge	1	07-12-2012 02:54 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:58 AM.