Calculate time difference to the half hour

Okay, This seemed to work.

=((TEXT(F10-E10,"h:mm"))-INT(TEXT(F10-E10,"h:mm")))*24

Anyone see a problem with this?

Thanks,
Ken



"Ken Ivins" <ken-express@kvins.com> wrote in message
news:uKujENwAFHA.2016@TK2MSFTNGP15.phx.gbl...
> Don,
>
> Thanks for your help. I tried this a few different ways with out
> getting the results I'm looking for. Any other ideas?
>
> Ken
>
>
>
>
> "Don Guillett" <donaldb@281.com> wrote in message
> news:eTalG%23vAFHA.608@TK2MSFTNGP15.phx.gbl...
>> try this
>> =ROUND(A1/TIME(0,30,0),0)*TIME(0,30,0)
>>
>> --
>> Don Guillett
>> SalesAid Software
>> donaldb@281.com
>> "Ken Ivins" <ken-express@kvins.com> wrote in message
>> news:utCnc1vAFHA.1452@TK2MSFTNGP11.phx.gbl...
>>> 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
>>>
>>>
>>
>>
>
>

Ken,

It's unclear what format you want the result to be in.

Try:

=INT((F10-E10)*48)/2

and format as a number, or

=INT((F10-E10)*48)/48

and format as time.

Tim C

"Ken Ivins" <ken-express@kvins.com> wrote in message
news:u2vueZwAFHA.2788@TK2MSFTNGP15.phx.gbl...
> Okay, This seemed to work.
>
> =((TEXT(F10-E10,"h:mm"))-INT(TEXT(F10-E10,"h:mm")))*24
>
> Anyone see a problem with this?
>
> Thanks,
> Ken
>
>
>
> "Ken Ivins" <ken-express@kvins.com> wrote in message
> news:uKujENwAFHA.2016@TK2MSFTNGP15.phx.gbl...
>> Don,
>>
>> Thanks for your help. I tried this a few different ways with out
>> getting the results I'm looking for. Any other ideas?
>>
>> Ken
>>
>>
>>
>>
>> "Don Guillett" <donaldb@281.com> wrote in message
>> news:eTalG%23vAFHA.608@TK2MSFTNGP15.phx.gbl...
>>> try this
>>> =ROUND(A1/TIME(0,30,0),0)*TIME(0,30,0)
>>>
>>> --
>>> Don Guillett
>>> SalesAid Software
>>> donaldb@281.com
>>> "Ken Ivins" <ken-express@kvins.com> wrote in message
>>> news:utCnc1vAFHA.1452@TK2MSFTNGP11.phx.gbl...
>>>> 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
>>>>
>>>>
>>>
>>>
>>
>>
>
>