•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Time In Lieu Spreadsheet
Hey All,
I have used Google Sheets forever but my new job uses Office and I am struggling with some of Excel's functions.
I'm trying to create a spreadsheet that tracks my time off in lieu (TOIL) so I know where I'm at.
I've created the bare bones of the spreadsheet ash shown in the image but I need help cleaning it up.
Ideally I would like to have all of the time columns (B:H) only have hh:mm format and then all of the 0:00:00 values that haven't been used not to be shown.
In cell L1 I would like it to show the most current level of TOIL, again in hh:mm format.
Is this possible or am I asking too much of Excel?
Thanks in advance.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#enterprise-level spreadsheet solutions
#Excel compatibility
#Excel alternatives for data analysis
#Excel alternatives
#modern spreadsheet innovations
#machine learning in spreadsheet applications
#digital transformation in spreadsheet software
#collaborative spreadsheet tools
#AI-driven spreadsheet solutions
#cloud-based spreadsheet applications
#real-time data collaboration
#automation in spreadsheet workflows
#no-code spreadsheet solutions
#AI-powered spreadsheet
#real-time collaboration
#spreadsheet API integration
#google sheets
#rows.com
#financial modeling with spreadsheets
#data cleaning solutions