How to add time to cell values

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

FAQ

Thread Tools

Display Modes

12-14-2015, 11:36 PM

macropod

Windows 7 64bit How to add time to cell values

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,467

Given there are 1440 minutes in a day, the simplest solution is to add n/1440 to the value, where n is the number of minutes. For example:
=A1+10/1440
=A1+15/1440
where the base time is in A1.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

« Previous Thread | Next Thread »

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 08:02 AM.