Forum Discussion
Timesheet
I have created a time sheet and worked out how to calculate daily credit or debit. Contracted hours are 7hr 30 and it’s flexi time so I need to calculate to accrued debit or credit too
3 Replies
- This is the timesheet and I need a formula at the end to calculating the accrued credit or debit
veevcf75 Thank you. Since Excel isn't very good at calculating with negative time, you could split the debits from the credits in two separate columns (columns G:H) like in the attached example. Or you calculate time in decimals and then format the end result in a time format (column I), provided it is a positive number.
veevcf75 So, why don't you share the sheet with us, indicating where you need the calculations and giving some examples of what debits/credits you expect to see.
