Forum Discussion
MTtracker
Oct 08, 2019Copper Contributor
Calculating Annual leave
I am trying to set up a simple formula so that I can track the amount of leave hours I've accumulated each month. I have a spreadsheet that tracks my work activities (that someone else created). E...
SergeiBaklan
Oct 08, 2019Diamond Contributor
In Excel one day is integer 1 and an hour is 1/24. Thus your formula shall be like
=(100+14)/24-C50
formatted as [hh]:mm