S
SysAdmin
Hello,
Thanks in advance if anyone can advise me on this one...
I have a database field which the user types in a hours worked for the week
and another for any overtime. I want the user to be able to enter 37.45
instead of 37.75 if he means the work was 37 hours 45 minutes.
TotalHHMMs: [BasicHHMMs] + [OvertimeHHMMs]
I have solved it by using a shadow field with the following calculation.
BasicDecimal:
((Int[BasicHHMMs]*60)+([BasicHHMMs]-(Int[BasicHHMMs]))*100)
/60 for hours
Same for the overtime field. Then i can add them in hours or mins
Also using (((Int(Mins/60)*60)/100)+Int(Mins/60)) to convert the mins to
hours + mins
Please, Please someone tell me this could be achieved much easier!!! A
little known field type for hours/mins???
If anyone knows of a good help for calc hours /mins then please post it
here. The solution above works but I am sure there is a better way....?
SysAdmin
Thanks in advance if anyone can advise me on this one...
I have a database field which the user types in a hours worked for the week
and another for any overtime. I want the user to be able to enter 37.45
instead of 37.75 if he means the work was 37 hours 45 minutes.
TotalHHMMs: [BasicHHMMs] + [OvertimeHHMMs]
I have solved it by using a shadow field with the following calculation.
BasicDecimal:
((Int[BasicHHMMs]*60)+([BasicHHMMs]-(Int[BasicHHMMs]))*100)
/60 for hours
Same for the overtime field. Then i can add them in hours or mins
Also using (((Int(Mins/60)*60)/100)+Int(Mins/60)) to convert the mins to
hours + mins
Please, Please someone tell me this could be achieved much easier!!! A
little known field type for hours/mins???
If anyone knows of a good help for calc hours /mins then please post it
here. The solution above works but I am sure there is a better way....?
SysAdmin