|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 17th, 2010, 07:39 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
to find the difference between time
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. 
|
|
#2
May 17th, 2010, 07:44 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
to find the difference between time
=SUM(C1,D1)-Sum(A1,B1)
-- Regards Dave Hawley www.ozgrid.com "Jogi" wrote in message ... 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.
|
|
#3
May 17th, 2010, 08:57 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
to find the difference between time
Forgot to add, Custom Format the result cell as : [h]:mm:ss
-- Regards Dave Hawley www.ozgrid.com "ozgrid.com" wrote in message ... =SUM(C1,D1)-Sum(A1,B1) -- Regards Dave Hawley www.ozgrid.com "Jogi" wrote in message ... 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.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
