Prev: Pivot from multiple sheets
Next: Find a number in a column then return a value from another cel
From: Jogi on 17 May 2010 02:39
Hello Sir,

I am a data entry operator in an organisation.

I want to find the time difference. For this please help me.

what i have done?

i opened a worksheet.
i enter the date 07.05.10 in first coloumn, then i entered the time 5:30 pm in
second coloumn. In third coloumn i entered the date 09.05.10, then i entered
the time 6:30am .

Now i want find the time difference between above mentioned time.

Please help me.

From: ozgrid.com on 17 May 2010 02:44
=SUM(C1,D1)-Sum(A1,B1)

--
Regards
Dave Hawley
www.ozgrid.com
"Jogi" <Jogi(a)discussions.microsoft.com> wrote in message
news:076C5E2A-6B62-4407-8073-8A919BEEAF26(a)microsoft.com...
> Hello Sir,
>
> I am a data entry operator in an organisation.
>
> I want to find the time difference. For this please help me.
>
> what i have done?
>
> i opened a worksheet.
> i enter the date 07.05.10 in first coloumn, then i entered the time 5:30
> pm in
> second coloumn. In third coloumn i entered the date 09.05.10, then i
> entered
> the time 6:30am .
>
> Now i want find the time difference between above mentioned time.
>
> Please help me.
>

From: ozgrid.com on 17 May 2010 03:57
Forgot to add, Custom Format the result cell as : [h]:mm:ss


--
Regards
Dave Hawley
www.ozgrid.com
"ozgrid.com" <dave(a)ozgrid.com> wrote in message
news:%23pvImyY9KHA.5592(a)TK2MSFTNGP02.phx.gbl...
> =SUM(C1,D1)-Sum(A1,B1)
>
> --
> Regards
> Dave Hawley
> www.ozgrid.com
> "Jogi" <Jogi(a)discussions.microsoft.com> wrote in message
> news:076C5E2A-6B62-4407-8073-8A919BEEAF26(a)microsoft.com...
>> Hello Sir,
>>
>> I am a data entry operator in an organisation.
>>
>> I want to find the time difference. For this please help me.
>>
>> what i have done?
>>
>> i opened a worksheet.
>> i enter the date 07.05.10 in first coloumn, then i entered the time 5:30
>> pm in
>> second coloumn. In third coloumn i entered the date 09.05.10, then i
>> entered
>> the time 6:30am .
>>
>> Now i want find the time difference between above mentioned time.
>>
>> Please help me.
>>
>

 | 
Pages: 1
Prev: Pivot from multiple sheets
Next: Find a number in a column then return a value from another cel