I am trying to see if I can get a formula to calculate how many days are remaining from how many hours I have left ie i work a 6:30 hour day if I have xx amount of hours leave left, how many of my working days does this equate to? not sure what operating system this is as for use at work.

Unless I'm missing something, this is pretty basic math. Your work day is 6 and 1/2 hours.

Divide however many hours you have left by 6.5.

e.g. "xx amount of hours leave left" = 40

=40/6.5 --> 6.154 days

Ask Your Question

Weekly Poll