Crystal 8.5 and Advantage SQL
Time Clock table has 4-sets of In/Out string fields we have converted using IsTime/CDateTime formula. These values display in the report in military time "8:58/19:53".
Then we've calculated the difference between each In/Out using Datediff("n")formulas and added the difference together to determine daily employee time. This displays as follows: In 8:58 / Out 10:37 - Hours 1:65. My understanding is that the Hours are Hours but the Minutes are 65% of 60 or 39.
How do I display the minutes as the true minutes - in this case 1 hour and 39 minutes?
1st Group is Employee ID and 2nd Group is to total regular and o/t hours by week. Had to use cdate(Val formula to convert {Time_Clk.Clk_Date} field from string to date, then used this @ClkDate formula to create a group with "Section will be printed for each week" option.
I need to show daily hours and bring the same format down into the weekly footer to show regular (up to 40) and o/t hours (over 40).
Final challenge is to report a grand total of regular hours and overtime hours based upon the week totals:
Week 1 - 50 hours - 40 regular and 10 o/t
Week 2 - 30 hours - 30 regular
Total 80 hours - 70 regular and 10 o/t...not 80 regular
Thanks for the help.
Time Clock table has 4-sets of In/Out string fields we have converted using IsTime/CDateTime formula. These values display in the report in military time "8:58/19:53".
Then we've calculated the difference between each In/Out using Datediff("n")formulas and added the difference together to determine daily employee time. This displays as follows: In 8:58 / Out 10:37 - Hours 1:65. My understanding is that the Hours are Hours but the Minutes are 65% of 60 or 39.
How do I display the minutes as the true minutes - in this case 1 hour and 39 minutes?
1st Group is Employee ID and 2nd Group is to total regular and o/t hours by week. Had to use cdate(Val formula to convert {Time_Clk.Clk_Date} field from string to date, then used this @ClkDate formula to create a group with "Section will be printed for each week" option.
I need to show daily hours and bring the same format down into the weekly footer to show regular (up to 40) and o/t hours (over 40).
Final challenge is to report a grand total of regular hours and overtime hours based upon the week totals:
Week 1 - 50 hours - 40 regular and 10 o/t
Week 2 - 30 hours - 30 regular
Total 80 hours - 70 regular and 10 o/t...not 80 regular
Thanks for the help.