Calculating hours worked overnight, (including 24 hours)

Hi All,

Can anyone solve this one for me?

I am trying to automate the hours worked on a site particularly overnight. For normal duties it is not a problem as I use the formula below, however I have some sites that work 24 hours a day and using this formula it returns zero?

=D19-C19+(C19>D19)

Where C19 is the start time and D19 is the finish time.

I appreciate any help you can provide.

Thank you,
Shaun.

Probably need to see a sample workbook with some typical data. Can't see how that would return zero unless the values are equal or zero, or maybe not times.

Regards, TMS

Unless you have a DATE/TIME field, excel will assume that 07:00 - 07:00 relates to the same day and will return 0.

Please attach a sample workbook. Make sure there is enough data to demonstrate your need. Make sure your desired results are shown, mock them up manually if necessary. Remember to remove ALL confidential information first!!!

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

I guess that, if a value of zero (0) implies that a) the start and end times are the same and b) that means that it is 24 hours, you could simply put a test in at the beginning of your existing formula:

Formula:

Please Login or Register  to view this content.

Regards, TMS

I refixed formula
New formula is below.

Try:
=C3-B3+(B3>=C3)