calculate in excel days remaining from hours

October 10, 2010 at 07:52:13
Specs: Windows XP
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.

See More: calculate in excel days remaining from hours

Report •

#1
October 10, 2010 at 12:36:39
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


Report •
Related Solutions


Ask Question