Figured this would be easy enough but i dont have enough knowledge in Java to do this.
Im making a time card for my field personnel, this time card has spots for a total 6 different jobs for that day(usually its only 1 long job but sometimes its multiple small jobs. So there is 6 start times,6 end times and 6 total times,there is also a spot for lunch. What i need is a script to calculate the total time one job took, IE Job 1 Start time 7:00 End Time 8:00 = 1 hr, then a script to add up all 6 jobs, deduct the lunch time( ie 15 min, 30 min etc) and give me a total time worked for the day. Can someone help me out please?
Job 1 Start 7:00 end 8:00 total 1 hr
Job 2 Start 11:00 end 12:00 total 1 hr
Lunch start 9:00 end 9:30 total 30 min
total: 1 hr 30 min
Will the day end before 23:59:59.999?
Any times that bridge past midnight need additional fields and coding to account for the next day.
Is lunch an elapsed time value or computed from a start and end time?
There have been many samples posted.