• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Time Sheet Macro with date/time data format

No I know. What i mean is, that it doesnt matter what time they clock in the clock in time will be at 6:00. e.g. total hours needs to be counted from 06:00. i.e. 06:00 to 13:00 = 7 hours, 05:30 to 13:00 also = 7 hours. Dont mean to cause confusion. lol
 
Hi there, Ok as per your file. The macro is currently running based on the arrival time being, e.g. 08:11 and departure time 15:49. that makes the total hours worked 7.6 hours (see row 15) what i need is to show the actual arrival time as it is, but the macro must work out the time always arriving at 06:00. so even if worker clocked in at 5.30, total hours must still be based at clock in from 06:00. Does that make sense? Sjoe even i'm finding it difficult to explain never mind write a macro for this thing. LOL
 

Attachments

  • Macro test.xlsm
    96.9 KB · Views: 5
@MonkeyNut

Hope I am not making too much questions, but I wan to understand few situations:

1. Time In-05:30; Time Out-13:30
2. Time In-06:30; Time Out-18:30
3. Time In-07:45; Time out-21:00
4. Time In-08:00; Time Out-11:15

Can you tell what results you expect in these cases?

Regards,
 
Somendra Misra said:
@MonkeyNut

Hope I am not making too much questions, but I wan to understand few situations:

1. Time In-05:30; Time Out-13:30
2. Time In-06:30; Time Out-18:30
3. Time In-07:45; Time out-21:00
4. Time In-08:00; Time Out-11:15

Can you tell what results you expect in these cases?

Regards,
Click to expand...

Hi Somendra,

Time in (Arrival time) and Time Out (Departure Time) will show as normal in Column G and H as it is in the spreadsheet, but in the macro when it works out the final hours it must work on Time In 06:00 at all times. Even if worker arrives at 5:30 (half hour before 06:00) or at 6:30 (half hour after 06:00) it must work the Hours from Time In at 06:00.

In other words, no matter what time the worker arrives, the final hours must always work on arrival Time 06:00. But we still need to be able to see in column G (Time In/Arrival Time Column) exactly what time they did clock in. So the final hours are going to be from:
1. Time In-06:00; Time Out-13:30

Hope this helps?

MN
 
Hi MN,

So time-in is cleared, what about time-out, you mentioned 13:30 as time-out so does it mean that if any time out is 18:00 than also count till 13:30???

Kindly, clear this.

Regards,
 
Somendra Misra said:
Hi MN,

So time-in is cleared, what about time-out, you mentioned 13:30 as time-out so does it mean that if any time out is 18:00 than also count till 13:30???

Kindly, clear this.

Regards,
Click to expand...
No. Time-out is as is on the spreadsheet. it is only Time In from 06:00 regardless of what time they clock in.

I used your example 1. of time-in time-out.
Time out will be exactly as it is in column H. (Departure Time)

However I still need to see the Original Time-In (Arrival Time) as it comes in on the spreadsheet. Only the macro must calculate from 06:00 to whenever it is they clock out.

MN
 
Thank you so Much. I apologise for late reply but was having connection problems. Back online. Thank you Somendra.
 
You must log in or register to reply here.
Back
Top