Working out hours from timesheet

[helenmeyer]

I have a gate log that lists incomings and outgoings of personnel. I would like to put a formula in that would work out the hours between the times. The gate log is set as follows:

[TABLE="width: 131"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD="align: right"]06:23.4[/TD]
[TD] in[/TD]
[/TR]
[TR]
[TD="align: right"]07:25.4[/TD]
[TD] out[/TD]
[/TR]
[TR]
[TD="align: right"]09:08.5[/TD]
[TD] in[/TD]
[/TR]
[TR]
[TD="align: right"]17:51.1 [/TD]
[TD]out[/TD]
[/TR]
</tbody>[/TABLE]

Any help would be appreciated.

Thanks

 

[myexcelcraze]

Change the time format as below:
00:00:00 AM
00:00:00 PM

A5: 6:23:04 AM
A6: 7:25:04 PM

A7: =(A6-A5)*24

 

[MandeepBaluja]

Set format of result cell to [H]:mm:ss in case your time is with date. A2-A1 will work easily to get the answer 24 is used to convert it into hours.