Good day
Need some help with calculations, this should be done between stages
each user story has a unique promotion REF and time it was promoted, i need to calculate time between promotions
Carla.xlsx (51.0 KB)
1 Like
bumping this post
Hi @neilonbooysen - Can you elaborate more on what basis the calculation is needed. Is Time difference needed based on same User Story and Current Promotion Name - Previous Promotion name ?
| User Story: User Story Reference | Promotion: Promotion Name | Time Difference |
|---|---|---|
| US-0002959 | P08112 | |
| US-0002959 | P08113 | P08113 - P08112 |
| US-0002959 | P09123 | P09123 - P08113 |
| US-0002959 | P09233 | P09233 - P09123 |
| US-0002959 | P09393 | P09393 - P09233 |
Thanks
Ankit J
1 Like
Hi @neilonbooysen, did the response provided by @ankit help in solving your query? If not, how far did you get and what kind of help you need further? If yes, kindly mark as solution the answer that solved your query.
sorry about the delay in response, this request was cancelled