LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Ntisch
 
Posts: n/a
Default Time increments


Hi - I use Excel Office 2004 for Mac.

I am trying to create a timeline of hours and minutes that I can adjust
down a spreadsheet.

For example the first value would be 2pm (in cell A1) and then I want
to increase by 15 minute increments down the sheet by programming cell
A2 as (A1+15), cell A3 as (A2+15) etc.

Is this possible?

Thanks, Nik


--
Ntisch
------------------------------------------------------------------------
Ntisch's Profile: http://www.excelforum.com/member.php...fo&userid=5791
View this thread: http://www.excelforum.com/showthread...hreadid=471621

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Time Manipulation BFiedler Excel Discussion (Misc queries) 0 September 15th 05 01:15 AM
conditional formatting with time values Access Idiot Excel Discussion (Misc queries) 2 September 13th 05 03:29 PM
Need formula to add increments of 0.16 seconds to time Tim Ashcom Excel Discussion (Misc queries) 2 July 19th 05 08:45 PM
How do I add time when some of the increments are less than an ho Learning Center Student New Users to Excel 1 May 18th 05 06:19 PM
unmet challenge boris Excel Worksheet Functions 2 March 16th 05 02:13 PM


All times are GMT +1. The time now is 10:28 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"