Clock In & Clock Out

[Vanda_a]

Dear All. Please kindly advise what formula is used with my situation?

My company start working on 08:30 to 12:00. And start work again on 13:00 to 17:30.

Alex is over 1 min and Jonh is 5 min. I would like to have a formula at column F.

	A	B	C	D	E	F
1		Clock In	Clock Out	Clock In	Clock Out
2	Alex	8:31	12:01	12:59	17:31	1
3	Jonh	8:29	11:55	12:50	17:30	5
4

<tbody>
</tbody>

Many many thanks

 

[exceldevs]

Very likely due to formatting issue, try go to Home menu and click on the drop down list for Number Format.
Then you can choose (or customize) desired format.

If that doesn't resolve try post a sample in the thread.

 

[ukmikeb]

Hello. I just got an other problem. some values return this "##############". however I extend the column, still no use.
I can't find the reason why. Please help

Many thanks

Hi

Check the result there it could quite possibly be negative.

 

[Vanda_a]

Very likely due to formatting issue, try go to Home menu and click on the drop down list for Number Format.
Then you can choose (or customize) desired format.

If that doesn't resolve try post a sample in the thread.

Howcome they are different format. I just post it from one scan machine.

 

[Vanda_a]

Hi

Check the result there it could quite possibly be negative.

I don't understand. Please give me more detail

 

[ukmikeb]

Hi

Create this :-
Vanda_a

	A	B	C	D
38		12:00:00	11:59:00	########

<thead>
</thead><tbody>
</tbody>

Excel 2007

Worksheet Formulas Cell Formula D38 =C38-B38 <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

in some empty cells, changing the cell references where appropriate, then hover over the "#######" cell.

hth