LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 207
Default how to trend a value every 5 minutes

Andrew,
1) Format cell A1 to Time (13:30) in the menu.
2) Format cell B1 to Custom (hh:mm;@) in the menu.
3) In cell A2, type"=SUM(A1+$B$1)
This will add the start time to whatever value you have in cell B2,
right now you want 5 minutes.
4) Copy and Paste A2 down the column until you have enough data.
5) If you decide to change the interval, all you ahve to do is change the
time interval in cell B2.
"andrew" wrote:

I have a valve linked to excell and would like to chart it to a line graph
every 5 minutes

 
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
Display minutes ONLY and calc difference tjsmags Excel Discussion (Misc queries) 8 August 29th 06 08:03 PM
Calculating and Adding Hours, Minutes, and Seconds in a CALL LOG EmanJR Excel Worksheet Functions 1 August 3rd 06 03:47 PM
converting Days Hours & minutes into just minutes in excel Six Sigma Blackbelt Excel Discussion (Misc queries) 5 April 28th 06 09:45 PM
How do I sum increments of minutes and seconds SandyMichalski Excel Worksheet Functions 5 February 2nd 06 03:02 PM
adding rows of hours and minutes to get a total Tipps Excel Worksheet Functions 1 November 4th 05 07:03 PM


All times are GMT +1. The time now is 04:04 PM.

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

About Us

"It's about Microsoft Excel"