Need to show calculation in time

Closed
Maria - Jan 30, 2011 at 09:34 PM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jan 31, 2011 at 04:38 AM
Hello,
Can you help?
If I work 104 hours and sell to 38 customers the answer is 2.74 however I need that answer to read in hours and minutes. Please advise how to do that.
Thank you
Maria


1 reply

venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Jan 31, 2011 at 04:38 AM
download this xls sheet from the url (maria.xls)

http://www.speedyshare.com/files/26596003/maria.xls

for easy comprehension I used structured formulas
see formulas in row no. 2 and E8
0