Excel problem

  wee eddie 12:24 16 Jul 10
Locked

I am working a shift that crosses the Dateline.

e.g. I start at 16:30:00 and finish the following morning at 03:00:00. To work out the hours worked I use the Formula =MOD(J3-I3,1)

Now I wish to work out the Earnings per Hour.

Logically this would be =Shift Sales/Hours Worked, however this does not seem to produce the correct answer.

The question ~ What Formula should I be using?

What am I missing?

  VoG II 12:29 16 Jul 10

Try

=Shift Sales/(Hours Worked*24)

Multiplying an Excel time by 24 converts it to a decimal time in hours.

  wee eddie 13:02 16 Jul 10

Thinking about it now, hindsight is a fine thing, isn't it, I should have been able to work that out.

Had I divided the Answer I got, with the one I knew I should have got. I'm getting idle in my dotage.

This thread is now locked and can not be replied to.

Surface Pro (2017) vs Surface Pro 4

20 groundbreaking 3D animation technologies coming to Siggraph 2017

iPad Pro 12.9 vs Surface Pro 5