|
|
#3
11-28-2023, 01:33 AM
|
||||
|
||||
Something like the attached?
I changed the value of E9 to show an example of overnight hours. This being said, your extensive use of merged cells will get you in trouble when you will want to analyze further data. Merged cells should be avoided at all costs. Also, if I understand part of your problem, when summing a range, XL does not care about text
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Power query - adding additional column | agreeff | Excel | 1 | 02-13-2023 01:13 AM |
 Timesheets to Invoices - Time being imported as days
|
dave6084 | Mail Merge | 1 | 11-02-2019 11:01 PM |
|
adding days to a date
|
euterpia | Excel | 1 | 01-18-2016 07:42 AM |
| Calculating Average Time across days | lizakay | Excel | 3 | 11-25-2015 05:16 PM |
| Adding additional job/education/reference category boxes in resume template? | Audible Nectar | Word | 1 | 11-16-2012 01:16 PM |
Windows 10 
Office 2021
Threaded Mode