try this
=ROUND(A1/TIME(0,30,0),0)*TIME(0,30,0)
--
Don Guillett
SalesAid Software
[email protected]
"Ken Ivins" <[email protected]> wrote in message
news:[email protected]...
> I am creating an employee time sheet that the put in their starting time
and
> ending time (From a drop down list). I would like Excel to calculate the
> amount of time showing full and if need be a half hour. My problem is that
> the results half only been in full hours. Such as 9 am to 5 pm comes out
as
> 8 hours. But also 9 am to 4:30 pm also comes out as 7 hours instead of 7.5
> hours.
>
> I have tried three types of formulas with the same result:
>
> =TEXT(F11-E11,"h")
>
> =(INT(F10-E10*24))
>
> =hour(f10-E10)
>
> Any ideas on getting the results I need?
>
> Thanks,
> Ken
>
>
Bookmarks