when you have xx:yy are they hh:mm or mm:ss? I'm signing out now. If you have replied & no-one else has sorted you out; look back in your Monday morning. It'll be done by then.
when you have xx:yy are they hh:mm or mm:ss? I'm signing out now. If you have replied & no-one else has sorted you out; look back in your Monday morning. It'll be done by then.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
the pause column:correct ones are h:mm... the incorrect ones are [h]:mm:ss... when checking i figured out just change format and fix this column
but the time column with correct in h:mm:ss and incorrect in [h]:mm:ss, when i change column format it give me completely different times...
25:27:00 0:36 this should read 25 minutes worked 36 seconds pause, when i change column format it sais he worked 1.25 hrs 36 seconds pause
is there a formula to determine if over 8 hours to remove last :00
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks