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!
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!