Time difference

  • Thread starter Thread starter aliya.pawaskar
  • Start date Start date
A

aliya.pawaskar

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
 
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
 
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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
Back
Top