Posted to microsoft.public.excel.misc

Hanr3

Posts: n/a

Time calculation for attendance, tardy/late to work?

I need to wirte an if statement that looks at a time stamp with date/time and
compatare it to the employees start time. If the employee comes in past their
start time, tardy, if before OK. Employees have all sorts of start times and
cross midnight.
Thanks,
--
Life is an adventure, are you living it?

These are just my opinions, please feel free to correct them if they are
wrong.

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
Time Calculation For A Timesheet To Include Lunch	poddys	Excel Worksheet Functions	2	March 3rd 06 08:05 PM
Time Calculation	Mike G	Excel Worksheet Functions	1	February 17th 06 10:50 PM
Time Calculation in Minutes only ?	pgcam	Excel Worksheet Functions	2	May 20th 05 07:35 PM
Time Calculation in Minutes only ?	pgcam	Excel Worksheet Functions	1	May 20th 05 04:46 PM
"Manual calculation" takes less time. Why?	Kjetil	Excel Discussion (Misc queries)	1	January 7th 05 12:28 AM

All times are GMT +1. The time now is 08:02 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us