Hi All,
How do i find from the start time and end time the difference and further convert to mins?
Example : my start time is : 18.40 and end time is : 17.05
Another Ex : Start Time is :12.00 and end time is : 02.00
Thanks
Hi @aishabhy05
Assuming that you have a start date and end date also associated with the time: If the start date and end date are the same then use text to number conversion formula ("value" in Anaplan) in conjunction with Mid to find out the hours and minutes. If the end date is not same as start date, then add 24 hours for every day difference between start and end date.
Example formula:
(End Date - Start Date) * 24 * 60 + (VALUE(LEFT(End Time, 2)) - VALUE(LEFT(Start Time, 2))) * 60 + VALUE(RIGHT(End Time, 2)) - VALUE(RIGHT(Start Time, 2))
@anikdas thanks for the help. But i m not able to get it right for the highlight. Also, the mins calculation is wrong. For the First item in the list below: The start time is 4 and the end time is 8. It should be 240 mins. but from the calculation which you stated is giving me 244.
@aishabhy05, you need to have the start/ end time with a certain format. As its a text input, it needs to have a certain format in order for the number formulas to work.
Hi, I'd like to know if my issue already occurred to anyone here. I created a saved view out of a module using different hierarchical lists. In the saved view, I pivoted the dimensions and restricted the view only on a specific line item. Then, I used that saved view to import data into another module however the data…
Hi, I have the following problem to solve and I’m not sure whether it’s even possible in Anaplan. I have List A with a certain number X of elements. For selected elements from List A, based on which I create a subset, I determine the components that make up each element. There can be a maximum of 6 components. Each line…
Hi everyone, I am trying to create a connection ADO from PostgreSQL, but I consistently receive the following error: Failed to establish a connection The following message was sent from the target system: The SSL certificate is either invalid or not in unencrypted PEM format. Please check your certificate and try again.…
