LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
C Tate
 
Posts: n/a
Default Question on using time in Excel

I am trying to work out some times in Excel. If the figure in, say cell A8,
is over 8 hours I want a formula which tells me by how much I'm over. If it's
under 8 hours I want the formula to tell me by how much I am under. Any help
would be appreciated.
PS: Usually I am just over under or over by several minutes. However my
formula must be able to accommodate the fact that do sometimes go an hour or
more over.
 
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: Add time to a date and time column? Nik Excel Worksheet Functions 3 April 29th 05 02:52 AM
How do I make a time Stamp in excel? Ben Excel Discussion (Misc queries) 4 April 22nd 05 08:37 PM
Historical Excel question statistical capabilities [email protected] Excel Discussion (Misc queries) 1 April 22nd 05 04:29 PM
Excel sheet for workout jogging time and graph Trevor New Users to Excel 1 March 7th 05 03:54 PM
How do I stop Excel from closing the open file each time I open a. Welsin Setting up and Configuration of Excel 3 January 8th 05 11:16 PM


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

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"