Team,
I found the answer myself, pls find below.
=(b2-a1)+"24:00:00"
This formula gives correct answer even if a>b or b>a...
On Jul 27, 2013 12:19 AM, "Basole" wrote:
> hi pls, which the provisions of values (hours) cell a1, cell a2, etc
>
>
>
> Em sexta-feira, 26 de julho de 2013 13h30min08s U
Hi pls find the examples
1. Diff between : 08:00 &15:00 2. Diff between : 10:00 &21:00 3. Diff
between : 22:00 &07:00 4. Diff between : 00:00 &09:00 5. Diff between :
23:00 &08:00
On Jul 26, 2013 11:31 PM, "Ricardo®" wrote:
> Hi, you can post example?
>
>
>
> 2013/7/26 Prabhu Pinky
>
>> Hi.
Hi, you can post example?
2013/7/26 Prabhu Pinky
> Hi..
> Am getting 0:00 as result for all examples...
> On Jul 26, 2013 10:15 PM, "Basole" wrote:
>
>> Use =HOUR(B1-A1)
>>
>>
>> Em sexta-feira, 26 de julho de 2013 13h30min08s UTC-3, Prabhu Pinky
>> escreveu:
>>>
>>> Hi experts,
>>>
>>> Pls h
Hi..
Am getting 0:00 as result for all examples...
On Jul 26, 2013 10:15 PM, "Basole" wrote:
> Use =HOUR(B1-A1)
>
>
> Em sexta-feira, 26 de julho de 2013 13h30min08s UTC-3, Prabhu Pinky
> escreveu:
>>
>> Hi experts,
>>
>> Pls help with formula to find difference between two hours. Below are the
>
