Formula to convert Hours to Days, Hours Minutes

J

jamilla

Joined
May 21, 2010
Messages
1
Reaction score
0
Hey Guys,

Just wondering if you can help me.. I'm doing some reporting for work and I am looking for a formula that can convert hours into days hours minutes.. I do need this to be converted into 8 hour days though - not 24hr days. It's to identify leave liability within our company..

eg: Employee has 1036hours - how many (8hr) days, hours, minutes is this.. Can someone help?

Oh - I'm using Excel 2007 if that helps.

Thanks! :)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding up total hours worked on employee schedule using various criteria 0
Convert minutes into hours and minutes 6
Convert a number to Hours, Minutes, etc. 3
Convert decimal days to hours and minutes 2
converting days, hours and minutes to minutes 1
convert hours and minutes into days 2
How do I convert hours to days? 2
Calculating Hours and minutes 5

Top