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: 12
Default calculating time

I am working in excel i want to put in a start time and an end time i want
for mon thru fri 7:00 am to 3:30 pm to be reg hours and any time before or
after to be ot I also want to add a luch column and to put in if there is a
lunch how much time was taken for lunch then i want it to calculate reg and
ot taking out a lunch if there is one taken - ANY HELP WOULD BE GREATLY
APPRECIATED
 
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 time increments from dates during working hours S Davis Excel Worksheet Functions 0 October 24th 06 03:32 PM
calculating time T.K.RAJU via OfficeKB.com Excel Discussion (Misc queries) 3 December 27th 05 12:22 PM
help with calculating overtime in a time sheet jongyrocka Excel Discussion (Misc queries) 13 December 10th 05 09:36 PM
Calculating a rate for elapsed time? Keith Excel Discussion (Misc queries) 8 May 18th 05 09:14 PM
Calculating tvl time in Excel 2000 Rev.9.2720 Brandi Excel Worksheet Functions 5 January 27th 05 09:15 PM


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