"Hello All,
I am trying to pull a time that from my Excel spreadsheet, but it keeps coming out as a decimal(Eg: "0.458333333333333" for 11am). What I'm trying to do is the send this time in an email so that other people could see at what time their class starts. The problem I am facing now, is that no expression that I have been able to build with the help of Copilot has worked in formatting the time to something like 11am. I tried creating an expression that converts the value into a Float and multiplies it by 24 to at least get close to the Integer value of the time. However, when I try to convert this to an Integer, Power Automate throws an error saying that the type I am trying to convert is not able to be converted. It seems like there is an issue with converting from Float to Integer, but I don't know how to get around it.
Please, if there is anyone that can help me figure this out, you would help me so much!
Here are some expressions that I have tried attached.
Thanks
Share
Report
All responses (
Answers (
53,362
