LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Lewis
 
Posts: n/a
Default Time Card Show Up Time

I'm working on a Time Calculator for work. On the time cards we have two
sets of In and Out on each card. If as an example someone has clocked in at
6:00 and Clocked out at 14:00. That person has worked their 8 hours and as
they start to leave a truck shows up and they decide to clock back in to
unload the truck. (the company pays them 2:00 hours as show up time. I
don't have a problem with people clocking in 2X and out 2X that is fairly
easy ((B4-B3+(B4<B3)+(B6-B5+(B6<B5))))

How can I have the program calculate (B4-B3+(B4<B3)) AND IF B50 AND B6<=0
ADD "2:00" BUT IF B50 AND B60 ADD (B6-B5+(B6<B5)) TO (B4-B3+(B4<B3))

--
Thank You, God Speed, and Semper Fidelis
 
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
Show timesheet time in and out in regular time versus military tim John Excel Worksheet Functions 1 November 11th 05 05:14 AM
Change to show time M Jones Excel Discussion (Misc queries) 2 June 1st 05 11:16 PM
subtraction of times, convert & multiply by a conditioned rate sanscull Excel Worksheet Functions 6 May 20th 05 02:02 AM
unmet challenge boris Excel Worksheet Functions 2 March 16th 05 02:13 PM
How to show negative time (e.g. -10 hours) Arhippa Excel Worksheet Functions 3 January 19th 05 08:53 AM


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