Posted to microsoft.public.excel.worksheet.functions

Andrew C

Posts: n/a

Time Increments

Hi
Theres probably an easy answer to this one but i cant work it out.

I have a starting time on a timesheet of 8.00am (Cell A1) i want to
increasing the time by 5mins in every cell below it. ie. B1 = 8.05am C1 =
8:10am

What do i use??

Cheers

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Time sheets	Driver	Excel Worksheet Functions	5	November 7th 05 11:19 AM
time sheet to calculate 2 different columns	John Sullivan	Excel Worksheet Functions	1	October 21st 05 06:48 AM
Time To Leave	Nicholas Scarpinato	Excel Discussion (Misc queries)	3	June 20th 05 10:18 PM
Accumulate weekly time to total time in Excel.	delve	Excel Discussion (Misc queries)	0	May 4th 05 08:14 PM
Time Sheet Calculation Help Needed!	sax30	Excel Worksheet Functions	2	April 26th 05 08:08 PM

All times are GMT +1. The time now is 05:53 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us