Forum

Hello, I have added another solution using IF and MROUND functions. See attached file, sheet IF solution. The numbers adds up nicely. Br, Anders

Hej Mattias! Have you tried using the MROUND function? To round to nearest 15 minutes you simply use the multiple of 15/(60*24), so the formula sho...

Hello Mike, No, didn't even know about it until now. Anything specific you wonder about it? Br, Anders

Hello Mirjana, Welcome to MOTH. Please read these forum rules, you will understand why as soon as you start reading it. Read This First | Forum Rul...

Hello, I am not clear with what you need help with, I mean, you have the values there. Can you examplify with how you want it? Apart from that, ...

Hello, This is not a forum for SharePoint, I am sure you know that. Anyway, check this support page. --> SharePoint help & learning - Mic...

Hello, You should arrange your data in a tabular format. See attached file and make a Pivot Table of the rearranged data table, you should get corr...

Hello, I suggest you take a look at Power Query, it should be the right tool for what you want to do. Br, Anders

Hello, See if the info in this Microsoft support page gives any help. Br, Anders

Hello, I am afraid that my reply won't contain much help, but to get a sum per category using DSUM you need to add the category/-ies as a criteria,...

Hello, Welcome to MOTH. If you haven't found this resource page already so do take a look, it contains lots of Excel treasures. Resource Downloa...

Hello Yuyun, If you can upload a sample file with some dummy data so we understand what kind of data you have and how it is structured, it would be...

Hello Lea, Ceck this Microsoft article about #date function in Power Query. /Anders

Hello, Have you tried using the DATE function? You will also need to use the LEFT, MID and RIGHT functions to get the values for the date. =DATE...

Hello, I did notice an error in the formula I provided. Change the M in red below to N, and you have a correct formula. Night: =SUMPRODUCT((L2-K2)*...