#1
|
|||
|
|||
Excel Hours Tracker
Hi all, new to the forum nice to meet you all.
I am in need of help. I am trying to do an hours tracker where I start off with a pot of 100 hours and then depending on how long I stay at work (I work annualised hours) I can plus or minus them hours worked off my 100 hours For instance I started August with 75 hours on the first Monday I stay half an hour after my finish time of 10pm so 30 minutes would come off my 75hours if I finished at 9:50 pm I would add on 10 minutes. I would like the same thing for every day of the year Any help would be appreciated I can get it to work if I stay after work but if I finish early I can’t minus the hours to put them back on Thanks Lee Watson |
#2
|
|||
|
|||
Something like this?
At top of sheet, you can set buffer time (100 Hrs in your case), and number of normative working hours in workday. When the number of normative working hours can wary depending on date - e.g. in case in your country is practiced shorter workday before holidays - then you need a calendary sheet, where the number of normative hours will be given for every calendary day, and in worktime table you'll have additional column where normative hours for WorkStart date are calculated. For Time format, the custom format "[h]:mm" is used. This format displays hours egual or greater then 24 Hrs. All other Time formats show only less than 24 Hrs. Columns WH, DB and TB are helper columns (you can hide them), where the number of hours is calculated in General format. Those columns are needed, because fields with date/Time formats return error whenever the calculation returns 0 or negative value. So all totals must be calculated using numeric values, and for final result those numbers are converted back to Hrs (TotalBalance column). I added a column OffHrs - there you can enter e.g. lunch time, in case it doesn't count as work time This table will work until TotalBalance for any table row remains > 0 |
#3
|
|||
|
|||
Hi,
I think this should work well, will use this thank you very much Regards Lee Watson |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Actual hours Excel to Project | JHalter | Project | 0 | 12-06-2021 03:43 PM |
Excel to Project work hours | JHalter | Project | 0 | 12-01-2021 10:35 AM |
How to adjust Project Duration for Summer and Winter Hours - based on number of hours per day | Lou C | Project | 2 | 10-03-2021 09:35 AM |
adding up hours as numbers doesnt match hours as time format | DBenz | Excel | 12 | 11-05-2018 02:53 PM |
Budget Tracker Excel | vill | Excel | 1 | 07-11-2017 01:14 PM |