Time Clock AM PM

V5 Question
41

Well, I think I basically have everything tricked out the last thing im struggling with is how to print a punch when a employee clocks in and out along with the total hours for the week… im using this report but im not sure how to pass the entity name to it…

[Time Clock:1,1,1,1,1,1,1]
@{ENTITY STATE ENTITY LIST:(ELSN=TCStatus) AND (ELSS=PunchIn)}
>Employee|In Date|Out Date|PunchIn|PunchOut|Hours
{REPORT ENTITY STATE DETAILS:L.EntityName,L.StartDate,L.EndDate,L.StartTime,L.EndTime,=F([L.Hours]):(ELSN=TCStatus) AND EntityStateLog.GetHours()>0 AND (ELSS=PunchIn) AND (ELEN={ENTITY NAME})}
>>Total Hours: {REPORT ENTITY STATE DETAILS:([L.Hours]).Sum:(ELSN=TCStatus) AND EntityStateLog.GetHours()>0 AND (ELSS=PunchIn) AND (ELEN={ENTITY NAME})}
42

image
image.png1764×475 26.1 KB

43

Update… got it working… now It all brings me back to my original question… How to change the reports from military 24hr time to 12hr am pm.

44

I think samba uses your pc time settings, is your pc using 24hr format?

45

Not its not… its using 12hr

46

You have to convert it using expressions.

47

Does the expression need to go into the script or the reports?

48

Leave script as is. Convert it anywhere your reporting it.

49

Do you have an example of that type of expression?

50

No not right now but there are tons on the forum. You could just do simple math to it.

51

hmm ive tried to add this for my report… FT([L.StartTime],‘hh’) but it doesnt seem to be working…

This is what my report looks like…

[End of Shift Time Clock Report:1,1.2,1,1,1,.2]
@{ENTITY STATE ENTITY LIST:(ELSN=TCStatus) AND (ELSS=PunchIn)}
>{SETTING:REntity} Clocked Out at {DATE} - {TIME}
>>Name|Date|IN|OUT|Hours
{REPORT ENTITY STATE DETAILS:,L.EntityName,L.StartDate,FT([L.StartTime],‘hh’),L.EndTime,=F([L.Hours]):(ELSN=TCStatus) AND EntityStateLog.GetHours()>0 AND (ELSS=PunchIn) AND (ELEN={SETTING:REntity})}
>>Total Hours This Week:			{REPORT ENTITY STATE DETAILS:([L.Hours]).Sum:(ELSN=TCStatus) AND EntityStateLog.GetHours()>0 AND (ELSS=PunchIn) AND (ELEN={SETTING:REntity})}
52

Here are a few screenshots of my time clock setup… Starting to really dig it!

image
image.png1528×866 36.4 KB

image
image.png1537×868 53.4 KB

image
image.png1537×869 55.3 KB

Test
Test.gif1555×881 1.92 MB

Test1
Test1.gif1486×823 1.33 MB

1 Like
53

I have a quick question… is it possible to access a entity screen even if a work period has ended. Mainly for just the time clock to be able to clock in and out before or after the work period has ended.

54

Yes you can with navigate.

1 Like
55

I asked this a long time ago when you were using timetrex and batch scripts for time clock… funny how things always come back around… I’ve searched and can’t find a answer. Is there a way to hide the pin number with * or something when a user is clocking in? Its not a huge deal but would be nice if a user doesn’t want someone to see their pin. Also is there a way to have samba auto generate a 4 digit PIN for a entity when creating their employee entity account for the time clock.

56

Just curious but have you seen our new beta time clock?

57

Um no lol… I would love to tho!

58

Are you part of beta forum?

59

Didn’t even know a beta forum existed.

60

Ok one moment I’ll add you.

1 Like