I want to use only a start and end time.
*24 works great for the day shift, but the night shift is wrong.
Does anyone know how to correct this ?

What numbers are you using, what formula, what result, & what did you
expect?
If you are using =24*(B1-A1), you may want to try =24*MOD(B1-A1,1)
--
David Biddulph

"DapperDom" wrote in message
...
I want to use only a start and end time.
*24 works great for the day shift, but the night shift is wrong.
Does anyone know how to correct this ?

A is time start, B is time stop, C =B - A, D is C*24 (number of hours). This
works fine for 8:00 AM to 5:00 PM, But from 5:00 PM to 8:00 AM it is wrong.

"David Biddulph" wrote:

What numbers are you using, what formula, what result, & what did you
expect?
If you are using =24*(B1-A1), you may want to try =24*MOD(B1-A1,1)
--
David Biddulph

"DapperDom" wrote in message
...
I want to use only a start and end time.
*24 works great for the day shift, but the night shift is wrong.
Does anyone know how to correct this ?

hi
do you have a date attached to the time. the problem may be that you are
crossing over into the next day. without a date as reference, xl gets
confused. try adding a date to your start and stop times and format to time
hh:mm. i think you'll get the correct results then.

Regards
FSt1

"DapperDom" wrote:

A is time start, B is time stop, C =B - A, D is C*24 (number of hours). This
works fine for 8:00 AM to 5:00 PM, But from 5:00 PM to 8:00 AM it is wrong.

"David Biddulph" wrote:

What numbers are you using, what formula, what result, & what did you
expect?
If you are using =24*(B1-A1), you may want to try =24*MOD(B1-A1,1)
--
David Biddulph

"DapperDom" wrote in message
...
I want to use only a start and end time.
*24 works great for the day shift, but the night shift is wrong.
Does anyone know how to correct this ?

hi again.
after thought.
convert your times to serial numbers ie format to general. with and without
the date.
you'll understand whats going on better.

Regards
FSt1

"FSt1" wrote:

hi
do you have a date attached to the time. the problem may be that you are
crossing over into the next day. without a date as reference, xl gets
confused. try adding a date to your start and stop times and format to time
hh:mm. i think you'll get the correct results then.

Regards
FSt1

"DapperDom" wrote:

A is time start, B is time stop, C =B - A, D is C*24 (number of hours). This
works fine for 8:00 AM to 5:00 PM, But from 5:00 PM to 8:00 AM it is wrong.

"David Biddulph" wrote:

What numbers are you using, what formula, what result, & what did you
expect?
If you are using =24*(B1-A1), you may want to try =24*MOD(B1-A1,1)
--
David Biddulph

"DapperDom" wrote in message
...
I want to use only a start and end time.
*24 works great for the day shift, but the night shift is wrong.
Does anyone know how to correct this ?

So, have you tried C =MOD(B-A, 1) ? That should solve your problem.

[Note that if you want help it's better not just to say "it is wrong", but
to tell the group what error message you are getting, or what wrong result,
and what you think the right answer should be. That way it is more likely
that someone will be able to help you.]
--
David Biddulph

"DapperDom" wrote in message
...
A is time start, B is time stop, C =B - A, D is C*24 (number of hours).
This
works fine for 8:00 AM to 5:00 PM, But from 5:00 PM to 8:00 AM it is
wrong.

"David Biddulph" wrote:

What numbers are you using, what formula, what result, & what did you
expect?
If you are using =24*(B1-A1), you may want to try =24*MOD(B1-A1,1)
--
David Biddulph

"DapperDom" wrote in message
...
I want to use only a start and end time.
*24 works great for the day shift, but the night shift is wrong.
Does anyone know how to correct this ?

David B formula should do the trick, or you could try this formula

=(B1-A1+(A1B1))*24


"DapperDom" wrote:

I want to use only a start and end time.
*24 works great for the day shift, but the night shift is wrong.
Does anyone know how to correct this ?