Time Clock AM PM


#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


#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!