slinky192001
Board Regular
- Joined
- Mar 16, 2007
- Messages
- 100
Hi,
I am trying to perform the following calculation in excel.
162690 seconds shown as Hours minutes and seconds and divided by 16.
I have enetered the following =162690/60/60/16. However this is giving me results in hours and fractions thereof (2.824479)
Is it possible for excel to calulate this in Hours minutes and seconds?
I've tried to make as much sense as possible apologies if this is a little confusing.
I am trying to perform the following calculation in excel.
162690 seconds shown as Hours minutes and seconds and divided by 16.
I have enetered the following =162690/60/60/16. However this is giving me results in hours and fractions thereof (2.824479)
Is it possible for excel to calulate this in Hours minutes and seconds?
I've tried to make as much sense as possible apologies if this is a little confusing.