Need to show calculation in time

Closed
Maria - 30 Jan 2011 à 21:34
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 31 Jan 2011 à 04:38
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


Related:

1 response

venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 811
31 Jan 2011 à 04:38
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