### time conversion help

Posted:

**Thu Apr 17, 2008 6:00 pm**Hello all,

I have a problem and was hoping some math guru can help me.

Here's the thing. Where I work we schedule our people with an

excel style work sheet, we bring our people in on the tenths of the

hour or every 6 minutes.

Ex. start time 606, 612, 618, 642, .......

Also the people are not allowed to be on the clock for more

than 14 hours straight. Our sheet has a cell that is labled

max hours which adds 1400 to the value in the start time cell.

So start time 606 would yield 2006 max hours. This works fine

except when someone starts after 1000 ex. 1100 yields 2500

which in reality that is 100 the next day. Any thoughts on how to

do that conversion so it would show the 100 versus 2500.

As you can tell we do everything in military time.

i think the fomula might be g7+1400 if g7>2400 then g7-2400

Can someone offer a formula for this?

Many thanks

I have a problem and was hoping some math guru can help me.

Here's the thing. Where I work we schedule our people with an

excel style work sheet, we bring our people in on the tenths of the

hour or every 6 minutes.

Ex. start time 606, 612, 618, 642, .......

Also the people are not allowed to be on the clock for more

than 14 hours straight. Our sheet has a cell that is labled

max hours which adds 1400 to the value in the start time cell.

So start time 606 would yield 2006 max hours. This works fine

except when someone starts after 1000 ex. 1100 yields 2500

which in reality that is 100 the next day. Any thoughts on how to

do that conversion so it would show the 100 versus 2500.

As you can tell we do everything in military time.

i think the fomula might be g7+1400 if g7>2400 then g7-2400

Can someone offer a formula for this?

Many thanks