Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time difference
Hi,
I am doing a time and motion study and we have 2 columns Start Time and End Time. the third column is the Time difference for the Start Time and End Time. My problem arise when the day changes, i.e. We work night shifts and if we start something before 12:00 AM and ends after 12:00 AM, the difference column does not give me result. Can somebody please help? Thanks, Aliya |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time difference
Select the cells that have the formula calculating the time difference and
click FORMAT, CELLS in the menu. Click the NUMBER tab and in the CATEGORY column scroll down until CUSTOM shows up in the list. Select the CUSTOM format and in the TYPE list box scroll down until you find the following time format: [h]:mm:ss -- Kevin Backmann "aliya.pawaskar" wrote: Hi, I am doing a time and motion study and we have 2 columns Start Time and End Time. the third column is the Time difference for the Start Time and End Time. My problem arise when the day changes, i.e. We work night shifts and if we start something before 12:00 AM and ends after 12:00 AM, the difference column does not give me result. Can somebody please help? Thanks, Aliya |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time difference
Try using:
=MOD(B1-A1,1) With the end time in B1 and the start time in A1. This works for any time of day. -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "aliya.pawaskar" wrote in message ... Hi, I am doing a time and motion study and we have 2 columns Start Time and End Time. the third column is the Time difference for the Start Time and End Time. My problem arise when the day changes, i.e. We work night shifts and if we start something before 12:00 AM and ends after 12:00 AM, the difference column does not give me result. Can somebody please help? Thanks, Aliya |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating Difference in Time (Amt. of Time Transpired) | 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) | |||
Time difference calculations, daylight savings time, Excel | Excel Discussion (Misc queries) | |||
Negative time should be allowed in Excel, eg time difference | Excel Discussion (Misc queries) |