LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default add & subtract time in 1 formula

Trying to set up a flexy sheet in excecl where it adds my start and finish
time in different cells and subtracts my 30min break and give me a total. I
then need to add total times up and if graeter than 37.5 h show me the
overtime. banging head against wall getting no where. Please can someone
Help!!
 
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
Subtract hours from a time and get the correct time casey Excel Worksheet Functions 1 June 22nd 08 08:41 PM
how to increment time & subtract time? Crackles McFarly Excel Worksheet Functions 9 November 1st 07 10:10 PM
formula to subtract time, 12:10 am (00:10) - 11:50 pm (23:10) ? teezee New Users to Excel 1 January 8th 06 11:11 PM
What formula is used to add or subtract minutes from a time in a . Lucky Phil Excel Worksheet Functions 1 April 17th 05 08:07 AM
how do I add/subtract time when I'm going from PM to AM (ex. 11:4. tammyj Excel Worksheet Functions 1 March 15th 05 07:31 PM


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

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"