Excel, counting work time with lookup function.

Does anyone work with lookup function with time values?
Any help is appreciated
Only need help with the lookup function, Cells: D7 To add correctly
D10 through D14 to add correctly
I’m having formula trouble looking up and adding time worked in one day, a week, and a month.
I’ve tried many formulas and formats but can’t get the correct time worked.
Using named ranges, Formatting is as shown.
Thanks,

I have to admit that I do not have a complete understanding of what you are trying to do here, but I do see something that might be the problem.

Did you intend the T1Time Range to be hours? Excel counts time in days. So 1.5 is 36 hours (one full day plus one half day) You might be getting into this problem in cell B6. You need to take the result and multiply it by 24 to get hours

=(Date5-Date3)*24

crossposted: https://www.mrexcel.com/board/thread...alues.1256438/

Rule 7: Cross-posting Without Telling Us

Your post does not comply with Rule 3 of our Forum RULES. Do not cross-post your question on multiple forums without telling us about your threads on other forums.

Post a link to any other forums where you have asked the same question.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Read this to understand why we ask you to do this.

I have added the crosspost reference for you today. Please comply with this and all our rules in the future

However, if you continue to crosspost, you can expect to have your thread BLOCKED until you update it yourself.

You do not need to do that. Cross-posting is allowed on BOTH sites, but on BOTH sites you have to declare it and provide a link. It's in BOTH forums' rules.

Since this is a new spreadsheet, it should be in a separate thread.

I think this is what you want. I converted your data ranges into an Excel table, You can add and delete data in excel tables and the formula and charts will keep up. Tables are dynamic.

I added helper columns day is the full day without the hours. Week is Day - Weekday (Day) + 7 which is the Saturday at the end of the week in which DAY is. And month which is simply =Text(Day,"mmm")

Columns P & Q also contain these formulas and some SUMIFS. You can hide the helper columns if you wish. Enter the desired date in cell Q2.