Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-11-2022, 03:21 PM
Loopylee2020 Loopylee2020 is offline Excel Hours Tracker Windows 10 Excel Hours Tracker Office 2021
Novice
Excel Hours Tracker
 
Join Date: Aug 2022
Posts: 3
Loopylee2020 is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 08-11-2022, 11:37 PM
ArviLaanemets ArviLaanemets is offline Excel Hours Tracker Windows 8 Excel Hours Tracker Office 2016
Expert
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

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
Attached Files
File Type: xlsx WorkTime.xlsx (12.1 KB, 6 views)
Reply With Quote
  #3  
Old 08-15-2022, 07:42 AM
Loopylee2020 Loopylee2020 is offline Excel Hours Tracker Windows 10 Excel Hours Tracker Office 2021
Novice
Excel Hours Tracker
 
Join Date: Aug 2022
Posts: 3
Loopylee2020 is on a distinguished road
Default

Hi,
I think this should work well, will use this
thank you very much

Regards
Lee Watson
Reply With Quote
Reply

Thread Tools
Display Modes


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

Other Forums: Access Forums

All times are GMT -7. The time now is 02:48 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft