Hi Thom,
I think I'm duplicating my reply, but I still haven't got the hang of how this forum works.
I'm working on a basic timesheet table.
- Days in rows
- Start/Break/Finish times in columns.
They're entered in 24hr time format.
So:
Times: Start Break Finish Total
Mon 09:00 01:00 17:00 07:00
Tue 07:15 00:45 17:30 09:30
Wed 08:30 01:00 17:15 07:45
TOTAL HRS: 24:15
I assumed I would need to convert these into decimals before being able to do the calculations, but maybe there's a standard formula or script for adding times?
I'd prefer a JavaScript solution, but would be just as thrilled with a FormCalc solution if that's easier or better.
Many thanks,
Peta
PS: I tried to insert an image, but it didn't work. And I tried to format the columns in the example above, so they'd align, but that didn't work either. So I hope you can make sense of it.