I'm trying to find the formula to calculate the employee hours worked in a
given day allowing for a half hour lunch. The time card entry looks like:

Time in: 6:00
Time out: 14:30
I want the answer to be 8

Hi

Excel stores times as fractions of a day, so 1 hour is 1/24, hence half hour
is 1/48
With Start time in A1 and End Time in B1
=B1-A1-1/48
For the cells with the formula, Format>Cells>Number>Custom>hh:mm

If you need to Sum the hours derived by the formula, format that cell as
[h]:mm to allow it to accumulate past 24 hours.

If your start and end times are likely to span over 2 days, then use
=MOD(B1-A1,1)-1/48


--
Regards
Roger Govier

"Danedel" <(E-Mail Removed)> wrote in message
news:F244994D-0774-4902-9274-(E-Mail Removed)...
> I'm trying to find the formula to calculate the employee hours worked in a
> given day allowing for a half hour lunch. The time card entry looks like:
>
> Time in: 6:00
> Time out: 14:30
> I want the answer to be 8

And, if you want the formula to be clearer that it's 30 minutes, use:

=b1-a1-time(0,30,0)

Regards,
Fred.

"Roger Govier" <roger@technology4unospamdotcodotuk> wrote in message
news:FD32179B-FCA5-494E-AF53-(E-Mail Removed)...
> Hi
>
> Excel stores times as fractions of a day, so 1 hour is 1/24, hence half
> hour is 1/48
> With Start time in A1 and End Time in B1
> =B1-A1-1/48
> For the cells with the formula, Format>Cells>Number>Custom>hh:mm
>
> If you need to Sum the hours derived by the formula, format that cell as
> [h]:mm to allow it to accumulate past 24 hours.
>
> If your start and end times are likely to span over 2 days, then use
> =MOD(B1-A1,1)-1/48
>
>
> --
> Regards
> Roger Govier
>
> "Danedel" <(E-Mail Removed)> wrote in message
> news:F244994D-0774-4902-9274-(E-Mail Removed)...
>> I'm trying to find the formula to calculate the employee hours worked in
>> a
>> given day allowing for a half hour lunch. The time card entry looks like:
>>
>> Time in: 6:00
>> Time out: 14:30
>> I want the answer to be 8
>

Or just


=B1-A1-"00:30"

--


Regards,


Peo Sjoblom

"Fred Smith" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> And, if you want the formula to be clearer that it's 30 minutes, use:
>
> =b1-a1-time(0,30,0)
>
> Regards,
> Fred.
>
> "Roger Govier" <roger@technology4unospamdotcodotuk> wrote in message
> news:FD32179B-FCA5-494E-AF53-(E-Mail Removed)...
>> Hi
>>
>> Excel stores times as fractions of a day, so 1 hour is 1/24, hence half
>> hour is 1/48
>> With Start time in A1 and End Time in B1
>> =B1-A1-1/48
>> For the cells with the formula, Format>Cells>Number>Custom>hh:mm
>>
>> If you need to Sum the hours derived by the formula, format that cell as
>> [h]:mm to allow it to accumulate past 24 hours.
>>
>> If your start and end times are likely to span over 2 days, then use
>> =MOD(B1-A1,1)-1/48
>>
>>
>> --
>> Regards
>> Roger Govier
>>
>> "Danedel" <(E-Mail Removed)> wrote in message
>> news:F244994D-0774-4902-9274-(E-Mail Removed)...
>>> I'm trying to find the formula to calculate the employee hours worked in
>>> a
>>> given day allowing for a half hour lunch. The time card entry looks
>>> like:
>>>
>>> Time in: 6:00
>>> Time out: 14:30
>>> I want the answer to be 8
>>
>