Time for another quick Excel tip.
Lets say the park near your house rents tennis courts by hour. And they charge $10 per hour. At the end of an intense tennis playing week, Linda, the tennis court manager called you up and said you need to pay $78 as rent for that week.
How many hours did you play?
Of course 78/10 = 7.8 hours.
But we all know that 7.8 hours makes no sense.
We also know that 7.8 hours is really 7 hours 48 minutes.
So how to convert 7.8 hrs to 7:48 ?
That is our quick tip for the day.
Simple, assuming the fractional time is in cell A1,
Use below steps to convert it to hours & minutes:
- In the target cell, write =A1/24
- Select the target cell and press CTRL+1 to format it (you can also right click and select format cells)
- Select Custom from “Number” tab and enter the code [h]:mm
- Done!
52 Bonus tips:
Thats all for now. Stay awesome until next time.
8 Responses to “What is LAMBDA? 4 Practical examples to REALLY understand it”
Thanks so much for this, it's utterly brilliant!
Silly question - I assume LAMDA will work with dynamic arrays?
Very much so. Many of the new functions like MAP only make sense in the context of dynamic arrays and Lambda functions.
As usual, very informative material. Easy to understand and apply!
Thanks for making everyone awesome!
Easy to understand Lambda function through this tutorial. Thanks Chandoo.
I have Officce 365 (updated), but I can't see LAMBDA function. 🙁
I dont see "Office Insider" option in my excel 365.
Another option for First Monday...
=LAMBDA(anydate,WORKDAY.INTL(EOMONTH(anydate,-1),1,"0111111"))
Loving the binary options in WORKDAY.INTL David...