| Home |
| Search |
| Today's Posts |
|
|
|
#1
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
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
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| subtracting date and time to find the difference between the two | Excel Discussion (Misc queries) | |||
| find the difference between start time and end time when spanning. | Excel Discussion (Misc queries) | |||
| subtract the time difference from another time difference | Excel Discussion (Misc queries) | |||
| how to find time difference between timestamps to a millisecond? | New Users to Excel | |||
| How do you find the difference between two time values when one i. | Excel Discussion (Misc queries) | |||
Hybrid Mode
