more than 24hrs problem

[Bundywa]

Hey all,
I know this will most likely be a easy answer, but Im going to ask anyway.
I been searching for ages now and nothing quite works...

I need to find the Penertration rate for drilling over the shift, I have added the meters (E46) and added the drill times (F46).
I have formated F46 to [H]:mm to get the total hours in 24hr time.
Here is were the problem starts, when I go over 24hrs drill time for the shift, The time seems to drop back (eg 26hrs to 2hrs)

the forumla I have is -

=IF(ISERROR(E46/(HOUR(F46)+MINUTE(F46)/60)),"",(E46/(HOUR(F46)+MINUTE(F46)/60)))

Thanks for looking..
Cheers
Bundy

 

[Special-K99]

Whatever the result of the formula if you do

=INT(your formula)

and format as General it will give you the number of days.

 

[Bundywa]

Thanks for the quick reply, but in the end I require the hr time (eg total drill time for the shift can be greater than 24hrs.)

For example, 1 day has 2 shifts. during each shift there is 4 drills which run for 9 1/2hrs.. so for the whole 24hour period there is a total of 76hrs drill time.

I need to keep the 76hrs to finish the equation but excel will drop it back to 4hrs...

I hope this makes senses..

Cheers