Calculating hours worked overnight, (including 24 hours)

**TMS** · 04-07-2015, 04:01 AM

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

**Shaun3080** · 04-07-2015, 04:22 AM

Hi Trevor,

Thank you for responding.
You are indeed correct in that the values for a 24 hour period are identical. The start time is 07:00 as is the end time so I am looking for a return of 24 rather than zero, if this is possible?

Thanks,
Shaun.

Calculating hours worked overnight, (including 24 hours)

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Re: Calculating hours worked overnight, (including 24 hours)

Re: Calculating hours worked overnight, (including 24 hours)

Thread Information

Users Browsing this Thread

Similar Threads

Calculating actual hours worked only in core hours

Calculate hours worked minus 30 min break if hours worked are greater than 4.5 hours

[SOLVED] Punch-Time Data. Calculating # of hours worked and # of hours worked alone per shift.

Calculating basic hours worked, between a time range and premium hours worked

Excel 2007 : Calculating basic hours worked, between a time range and premium hours worked

Bookmarks

Bookmarks

Posting Permissions