LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
SheriffCassidy
 
Posts: n/a
Default Calculating the difference between cells

I'm new to functions and formulas - how do I create one to automatically
update a cell so that it shows the difference between two cells that display
times.

For example, cell A1 contains 2:30pm and A2 contains 2:45pm - I want A3 to
display the difference, regardless of whether it is a negative or postivie.
In fact, I would prefer that it made no reference to whether it's a negative
or not.
 
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
Calculating Cells - Slower in Smaller File Diane Alsing Excel Discussion (Misc queries) 0 February 4th 05 04:17 PM
Calculating current age from 2 date cells dhealy Excel Worksheet Functions 1 January 19th 05 04:50 PM
CALCULATING CELLS AS A TOTAL EDDIE Excel Discussion (Misc queries) 4 December 23rd 04 03:27 PM
Calculating time difference Robyn Bellanger Excel Discussion (Misc queries) 2 December 23rd 04 02:29 AM
Calculating without including Hidden Cells LiquidFire Excel Discussion (Misc queries) 3 November 29th 04 08:35 PM


All times are GMT +1. The time now is 10:26 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"