are the figures seconds or minutes?
Is 15.30 for example 15 minutes and 30 seconds etc? Or would it be 15 hours and .30 hours?
The nobler man first practices what he preaches and afterward preaches according to his practice.
Bartolli: Try typing the following into excel. Change N15 to whatever the cell reference is that you want to convert eg A1, B4 etc. Make sure you get all the right brackets in the right place! This will display the result: 5h 12m 49s if your input cell reads 5.2136 etc. =CONCATENATE(INT(N15),"h ",INT((N15-INT(N15))*60),"m ",ROUND(((N15-INT(N15))*60-INT((N15-INT(N15))*60))*60,0),"s ")
Try typing the following into excel.
Change N15 to whatever the cell reference is that you want to convert eg A1, B4 etc. Make sure you get all the right brackets in the right place! This will display the result: 5h 12m 49s if your input cell reads 5.2136 etc.
=CONCATENATE(INT(N15),"h ",INT((N15-INT(N15))*60),"m ",ROUND(((N15-INT(N15))*60-INT((N15-INT(N15))*60))*60,0),"s ")
Or =TEXT(A4/24,"hh:mm:ss") accomplishes the same
That made me laff, so much simpler than my "clever" formula!
If our guys were on the phone for 15 hours they would be shot, its mostly minutes and seconds and lots of odd seconds, like 38, 22, 19, 5, etc etc, when youve pages and pages and numbers to check it makes your eyes go funny, most of them are small and not too hard to add up but several users (fishy slaps their legs) makes pages and pages of private calls and FOR THESE THEY WILL PAY. thanks di
Some calculators will convert decimal numbers into angle notation, i.e. degrees, minutes and seconds, said another way that is hours minutes and seconds.