Adding Days and Time in Excel 1

[MWilson85]

How do I add/subtract time in Excel? For example, using downloaded information from our PLC in time format which has a column for time: 10:00, the next time is 11:14. Can I subtract 10:00 from 11:14 to get 74 minutes?

Also, trying to graph time and data is nearly impossible for me to do. Any suggestions?

 

[MintJulep]

Excel's "unit" quantity of time is the day.

This FAQ on Eng-Tips sister site Tek-Tips may be useful.

http://www.tek-tips.com/faqs.cfm?fid=5827

 

[mikejeffers]

Are you in Fort Dodge by chance?

 

[MEM1]

=HOUR(B1-A1)*60+MINUTE(B1-A1)

 

[electricpete]

or else =+(B1-A1)*60*24
(make sure to format as number instead of date)

=====================================
Eng-tips forums: The best place on the web for engineering discussions.

 

[MWilson85]

mikejeffers - located in northeast ohio!