Hi
format the cell with the custom format
[hh]:mm

--
Regards
Frank Kabel
Frankfurt, Germany
"DMachado" schrieb im Newsbeitrag
...
Hi
I need to calculate the production time for a partcular machine.
A1= quantity to produce= 4,800
B1= production/hour= 200
C1= production time= A1/B1 returns 00:00 (format is hh:mm), not 24:00
hours.
Could somebody help me with that?
Thank you and happy new year!