Posted to microsoft.public.excel.worksheet.functions

Susan

external usenet poster

Posts: 271

Time Sheets - regular vs overtime

I am having an issue with calculating the time for regular and overtime. I
want the results to be automated and every formula, if statement and min/max
statements I have tried are unsuccessful. Here is an example:
WEEKLY TOTAL
Total hours: 92:20
Regular hours: #NAME?
Overtime hours:

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
how can i highlight dupplicated in 2 sheets at a time?	Rana Usman Khan	Excel Worksheet Functions	2	April 10th 06 10:33 AM
How do I protect multiple sheets at one time?	Kelly	Excel Worksheet Functions	1	February 27th 06 04:30 PM
Time Sheets	Lady Layla	Excel Discussion (Misc queries)	1	March 23rd 05 03:22 PM
Time Sheets	Helen Black	Excel Worksheet Functions	0	March 21st 05 09:32 AM
Setting up scheduling and Time sheets for Payroll	Mich	Excel Worksheet Functions	2	December 30th 04 06:53 PM

All times are GMT +1. The time now is 03:51 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us