Need to keep up with time for a year on the time I am allotted minus the time I used and result in hours and minutes.



Thanks
Esther

=time allotted -time used and format as [h]:mm

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

This requires nothing more than a simple subtraction. If the time allotted is in A1 and the time used is in A2, the time remaining requires nothing more than:
=A1-A2
in whatever cell you want to display the result in. Excel will automatically display the result in days, hours & minutes. If you have more than 24 hours, format the result cell's display as:
[h]:mm

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]