Forum Discussion
How do I find Origin of an excel sheet?
If B1 contains a umber of hours, for example 36, you can use
=B1/24
to return 1.5 as the number of days
- In Excel, click Power Pivot > Manage to open the Power Pivot window.
- View the tabs in the Power Pivot window. Each tab contains a table in your model. ...
- To view the origin of the table, click Table Properties.
Find out which data sources are used in a workbook data model
If you're working with data that's been added to an Excel data model, then sometimes, you may lose track of which tables and data sources were added to the data model.
Note: Make sure you have enabled the Power Pivot add-in. For more information, see Start the Power Pivot add-in for Excel.
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
- NikolinoDE I figured that one out. Thank you for your help.
Now I am trying to convert a column with hours to days, do you have a formula for that?I don't know exactly what you want / need and what you want to calculate,
but I am still sending you this file with the time calculation.
If that is not exactly what you want, please explain again in detail
(on the basis of a file, without sensitive data, would be best)
and I will try to help you as far as I can.
Thank you for your understanding and patience
Nikolino
I know I don't know anything (Socrates)
sry now i see your question 🙂
here is a examble hours to days with formulas
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
