Formula to convert Hours to Days, Hours Minutes

May 21, 2010
Reaction score
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