Calculate End time

Hello everyone,

I have a table that has a Date column, Total hours and Time.
I need to determine start time and end time in my visualization.

How do I do this in the query editor
CAL.pbix (57.2 KB)

Sample PBIX file attached

@Melissa @BrianJ @sam.mckay

Hi @EmmanuelBassey,

Based on the Date and Time being start values you can calculate the End Time based on the numerical total hours, as illustrated below:

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("jV1Lruw6jtxKI8eNc0X9LJ1ZLaCBmjd6/9toU5LTERR1X+WgCrjvZNqWKTIYDFL/+7+f9EfSnxhi/Pz3J/z0VOjT7n+V8Jvjb07/9a//+fzff9tvSOhXxM/9r/E35d/U/+vf3hdCS/SJXa8Rf0v+je3wlRDixZ82LlPKb4rwnfh8R36uVO7/L7+h/8bs/+x1CX7CeNjfKL+ler8ZfvL9v/k33z8anj8Q+SNN/0LGX5TCq5Hms0n6Den9zSjvb5ZaU3s/Xa/RdMGLPAuu13gvkVPtGT7XuKly/Up0byr+hCx4Cf1C/w3lt4TvFcKfBJcond7o+Nf+e9tBCfAQ5X2IWAOZTR5fiLfVZHyI/FxCfnqgb9S5Tqn9xg52hpfglyXrEvdSfb8Q/+T3/d9rj5883m2qt5l9V+nPBWbcG92QLtJ12/BvvOAJKqxR5Ecu6023+yLPFW7TASO++EWP95wiPTCuaar8mcYXAhgfPLC+5RTMija11fzaERiz/j2ZUR0bKl73hoHbL++C5pgvs8/v27nXNIHZRbS6q4xFvC0txvcdpfcnGz/hNMzbBkI5bC9jNWPRb7eRYRHjn9uY34c0qzjfarsdx3dR7luO7xVCor0yXtO9WdQUvGUMPzVPP3PvDvm+eL2F/v7o/Zv0KdOrqvHi/sjwjekGbmsKFTZphLWIxtVM+ygNPKLAWoSfJuJ4Gul4ibj23HqFiTbFtW67/5YItx3Tu61DTBU26bilJL/569jvK8DChEh7Yi63yDDbiM4pvJdoUchwxyu9n0LS+4IqWgBdYAW0UuEZbkdzvUbZZfv98SKk4Yu44EVI8y5xW1lquEzgPOolZJZpbL7cKfLAPSVa1bms4XaXBd40xJRk/HeZe1vv6d3bHZxfnjv1jjoi70aK6C1SFrNV9RmD7lXw8AEc5NXwpkd0VYP/TehRYevd/pGeMk1buF9VaAdbyL1bn6SGAO5AGKyYV9XHY0cy0Psb9b1Cz1ucaupwMr1aMGmpOx4Sddq/ERBUhJsqMzQlcOz3f81w19F87n+tCmykAE6p8IVkPuttJfU3/3aNuEZa+zA9ZQm4D+Nay+UcInkTma713rjhtaAOBpQZwI1nuO9ILrBheIYr8CNccx/e4STjPgRjuBdmv0K4TQ7jMSzrjTzpTU0/nuX29v6yxouh63q1cl9FvEvoQ2/O7TaD31jB2q73CUrkCyx/e29dOSA1E5MfvJnGMsGbJjRI+zJO68vwIszOzx13/gTJ9zaOAqsUXl9VQonmNXS1izfKAAYYsMWa0R2e9RvgiOCltbrF56wwKmCIeYPYvb3atoP7eAmIrzusTyrNvOT77yt4xkRh9Zp2kxCY0eaSH2kUUVb4v0N1iF74v9fwSlvgvT3h7Z4JT6MhOBCjrMd04JyuO72l9Vov2C2yzOb7njY8reHiNh0P/91Y7SK7qcuac9Ug913J9i5kZkCap2UGTAt1XQvs+M45wYTUAeMu+izdwZvx6Aa7FMS+L1fepzYYvMwXMfy5i5nU9+4Gei9UbprQ/Xu/hgK5iTHxRw2ydyDSHc0FUHXELZUsCKv661K96y8wETj6YNJrsuQ+wMTt9CJm3pAoyFXtWxkOAy0LMq8o5nP/q7pI3RxvZMB4ea0tdy/B6+XiH4FbaMQyrJy6qZ9+0wTMtTJHv4X6BXJqBIn3PWQ2jGHcGi4TcA14z+V5C+AkMPNwN5hGeEptaAMvY8wCyALDj0LlDZjeECCATxBaBrMB88rKb3xEjgozsppok18yb+rG/IVgHrgqC7Dn0pSMkZ087IH+yQMzNQ8C364hbciwaubyQiaCkhpY3s39UgoGt8fOCzpZgpL0tXsBWt8qReiJkooSFwec/WTNeidvXrbuYkWcmS5o0APzp7x6B+sjvYjdi9mDIbLIe8Di15GSpy6VX0aaxh3vB/OhVux0Q3WSH1HpEh/yGpAyYUocl8iHHdnZ79bHr0WKyhAMUncy/ZF8Yi5wwbuUHdkPPAepp3ACvWOtpkE2EoZF8JGLdVxzxybHzylHtHZoU3jiestqEOLMBVPXNOzfzk2Lbmm78krPGqYHb7psDjwO1EqEJOy1Ow3b8pO+8tPDNtq3syLvzlsVENQNb5ws7N4yxCugWwrdMAVzFyj+oOfAm9oMaO7b4F5CbqhI9zRDb4lALWBYckNC0htKaKHgnoT5mkXDhsQcI3KSxXzmNtPX7V5Cb6la4+hKPseCz4yJpXnViyfNF5HJuJNFroWQJXHmg0SdWNww9tYdskvyosi9+Pt2F91ajNoRXTb790kdUMYIEsGqQzSL+fjdjMkYo8W0njXqGibMOxHMbKFPNK9NzVu/+++F7qIukBtwZTh5uJywJsrbCiQP7yXU8rcqR1M7C8g1gxMyOKSte8rpToJcIlZTIMephEvpBTdiXF/LalymAHd5A0cCEitbVmx8KGxI2wnnrluQ1pKyx50yjbqUJzSbAyObaWcaVOK79sijJHyGCemUw3V98/0AJgu7nhBEDxCBejYsXLjeMAdoADdsS/wIE55wTAp/kFSrtEh5oPl7K+bvBmicwhe+p2U+GsQSBgwgg/q1xeoBv9PXQgux6Xds3xFm0TSn4ENgwCiRc4DFFBQwJoM4YsrbXZVB5EZ4cCwyBd43M5G5X0UK3soq2cHE8mJfhJ8C935pC38nhVbv2lB8nyYQOmxwXr4rO5fNmLzw33dZKRyhBHoUKZwmTKJf3/nX7/FvxlycvRob1DkLU7Vlx5hqVoUxI9xTq5SJtAXnA/D2bLm9cEa1OG1JWPkJgDLVrBj6ziCeLkSZXF5q5iJlWEmpkOwYY4/m89xW1i3ortVVCJgmiCqIwHCtwl4K72pDWLHHQs1OSCl3C6iTcpB2pQ2JqJu6NED/a/t9rZvvQKQNDgHqqRgt2g5S7whXiSgRyLbnNtHtTH8BiWzuHE3aMJ/cwVGmlV2v8FMdKkXBwgE6BWM7q1Sk7zUCAnltQX7KNwaGQwzshvVuE/N1oKtwIdRrccxZqRhuK/6CcVpfmk3oEnhPwcTlOlkjTYmr/3bMJZYIIvBDYA3FVl3eSA5J9Cs4md4pHe84hmtWqzVpuXwMIwyrxr8mJXhIUoBU2+7t06Br0KRBFBPbVmC4dNFS8SN72jGwkr6BUBiuWu5EXJdpKwrlsa6Y6JG/RfwE5SzMUjzYllfe7e4zUzqaD6oiAVoYum/zmZl6ycTn4Uq2sjm3qgGP/h5fvxP600iqD1s/RPMIeV4iK9RzX1ZIhiabGqk7U6B1wl3Emf70L1Gdbna53dsgzGfRfRKOdi9958Ob+rDgFibWLaRC7ggMpk2/nSLvXCJzd8edNXWIBV4+slOTcSvl6NFMXS7N131n7viTaLI97OBFIT3UMiLTVzN2sBdGe+gOZyKaQeVyCjbOy1UAzKU1lNmZe87LD0fMj+Jeuw5LEudWt3PlYDDTV2UM3HLEgExEXj4FdOQYkF18xTR4C/b1JhU3nCJcMPlFWOIsrpng+41lj1hDAxSTF5lvz8t/P0OinMDEnYV9Vv0uwE7Eh5L1WIpv68HnWBcyN0IFOgJVJjMiVlrG738tz6s2f4AmGo3zn+HIaB+R5O1iFXFFfa5AGex10koJbHtqbpmDzw1S9y0wMrQsvrFWI/5aBEHOIBChKsy0EzY9NGbD56b1g0brihBgoszOPDdUJE1se9jZxpaEt3BVJ4+6r5Ah8tCevngDLmgltM4ceAzem9snC/smovcdqkwlw1RwA/TmxPNrkXfHLV8YCSVisJY00cQtxKRGZtYewJgPek1f12xiI2cYM0Mt55uQbliJiWMKaVpwizQWgebPk7gTA4xJS5/pf+4Ev767+hHmlqPzvF36Rh42fTeSffu695hVszWNpeFvMUa0FIrrCNj+41SwKXSGVVOLKC01vrIzxpyrIlioM1nRYm4HhxzLCfTvlMSlKuRwwRcMuBkiYlptZFKd3Vx1+1NpD/FX8BIfpVHqwY5z3zVFaezNw26ObQc7UxeVmwfR4k/1tvNfkrFgwm2djy2ZyAQqIMqy60ZAA+Vfn5Uak9wLFqIUfqqntB2AYYhUmPVzaXQqfc9kIhdO2Xkf+gkUkXXfkCWGXdgzCvIkF0Gj8ySycbB99eDwu/PC41AiuKKww10NXgLxMGcB6hPKIaj1ulv1UKOTD0Andi0f5vrZmHZJQtLbi1BgJ89tnP3Sw6o1HTZuN/twQgcZOPhQ/KN7esSAFYqkJo2phhQZxjWpfjdZjw++z6ArS0ww9E3033UHFPETpWAXZlWwE8sLcV1mEEzM9aDtpMDigaX4DmxsyFqUvZdD/XTj1BklWAZZzoqEXCSYfu9aiRdPYXHHl4QJIdzTNd+G8XHo2KXtfOboHEqwC9PfTXA2cBzYx9t7bErI0ThUEEwgZZYcFZWmkBc4EgyJlfmHxSqnCsoe496MHnvhlRhII4j2ZYFgmm+qH9GDzdyXLNjQvsDsSF4aCa2bH+QppgUrz2wtBdaLUapjqktPIlAotbaMQNl4WcRRNWy5RR/0c/Vx0KM7xeJfwj6AWsIWnpL6Tbl8N5zLJsvIK21+3cnrhn8WdxMOSE6fabfRuWs8cPrVTv6Ff0gLc3VeR/JZn0X/xO7b0D+WClY2PtWqR5R0rbAiAI0lgs7lTnHz9kqnW3ENUVy8QXe+N22NQn1xhWDag/Gg2oS1UpPnOwrXMNI97HBA2tlRuPI7qCZPXk2NwiwhCnN5nRa5Fc+5luH/a31C2Ynzy0E2ZXoe4VR8KxEmrupTOI9U3kHXxH2ZbVnqRdAcdL2OkiYP7+ryMXHLyz9LZfUm/qYWFC8OnCsECcn0SDAqTmNSblTgIGmP8xKmZOPEg8UHU8sxvYuF/eDciSp9P/XTOBLtNLqvfNRe3Zo6E9Bfa58+M5bj7fbl2NspSSiy74VRKUfWCpGDiXAriBqfSIhqb1GaYtrohaLkbl7kjR2Sa2S52Hj9DTPZ+7nMzjaPDpbD64uvIgX1qULFYcbzk2OIF/k9zIHEAovP4mdJoJr+bsmjxkkhAsHU9IHSjz7QK5temtpnt81LfvJul+YWKLpblu7b4pWCvyiVVcFhlasLpCwUjKU+YjY1/wO/WXaYW7Uwgj6PoHndi1p51I8OjeLVsL71QYgJxWxY6Y2ODlj1FuKCJG+7XcsNu07yWZRsyo/oR7nCuTJwZRqy9+qfqQJyetWS92rjSDZPQE4iA9rH9RtWjmhBk1FzvmMWKS1e24RbKj7ERZW6NbrSPWCot3j5X6jc+X0t7l+Y99q4m2RoROyfNo+0/HLmeybD2rm6MuRFoOamquFTDNd+8+g7HkMjzG1ctYEP+fzN/lR0cKY/+kp58mjtdt73CsRtlay8BexGfLywa6cKNz6I6d2Nj6qvMZ2Kkc4ApumQYqByNX7BSeu7LhWRpeTBNmp6ICb0NdROzG9iIoMYjyB0KUCMmeO26ey8FtchIP4yUodSHGJNqzsHQHVoppkQC5kielV1X0gZaly/XCOr3ylG6N02pTbzmRriVI67Kfo7FAmI7CC1S28zFD8xkWbLg9NHHcxJWnyqzZHr1xft+s1I9Y030LKTs76ovW/OZRjEdDrUdUMz3n1SP/fWTG5qIj81eMwgD8/5D0b0EE7/Z0K0rQKcY7huMtM2kFl46xQNyySe4mrvTsqk8Y3uPuX8xdKpMZO4iN3RlmFNB/HT07YQy8lH+gUCYn1WBagcXcRiK+rRmxvhvMzNqjMLDpNdjLolfxb7dZRL2OA+0XKKUCEybq2lrTFF2S/snGc3JSuP6sQA4F9cYe/G0jFVOrHHT7yiJ0idIMtlAJKR3LzNVhQ/SJWxR/zZ6Y0Ku/wPOy2v5NIvALLLCv15u5SpYP9uoBw9TJmF1hEw0qORmhLjCikC/SlcdJawTUwp+iLoAuim/5HadOfC1DHuC74BBpYnD6wcHlRsQH+TGYvNP0+GNiYnTp9VRQvC1Rcs9TayxjjbrrW2j6tGHpMj95ILFKW/D13KdmfPeCVI6LC+LxoBzNxUWnSCttmIjT3f3quUcPQVQcGwVXlWjhVh6JuBwsGHHJ3eF+5WT1Ywmp3TAR+YVonWx4vXN4AMO7LdcUeTVfVN8UTiezIxlXweFVi3i+LnXpN4BFIAWQTwclKZd+uq6pj5cVjvNRrO+FnKF6qswhveW1JnYAeXhoi4ucXhGKlqRBIGso3YvhfIfmwIxqgfJX/CqQyRAvfFaGa15hVmZjF5jMFh1HKmeIXqvrgzMTImAwYofbEqa5H7WSiDIvPxxPlp5DvoIujdeoK6WOkSRJayD5oqiUDdnGRt0WSoSxXV4ALpD8nZGHnKjD46ZEc8hzK8HKXtM6XSEtShiJgMuliD+/Q7sAFgwwiv0XfcBfaiU7/delGYNfKyX/OaZhwXTewwGdQAr0VA70Jt2lF2Rc0o7RJ58f376VWEdxjJVY1XWZtSmHXDPl+H+ssD+hZvx4gVnq3pMJH4I/x9Mbn8V0xaTnCe88m14gXecmTyJdAWjpOlM+MfCUIYolEW5gzp0NU6hno4IxFLIq2NUTvwpz6wgi6BLErjhXo0RQUK3ryBpOwdqGO+qk/UyE/aVSB5dNrWww7t+5yeonwmNp0Q0uEBSasx4X6ElLwvyE+o2wwM9aY0hZEBRt3KSnHVxVz/bh/ZlW8QVuiGBKmfpaZHzEoqWuOKy9Tfa7en54vd8WhToIRJGFART3musTwfbceUWeLnqUOhgggn6zxsRUi0TTr9iVNw1lKQi/X1C7v0a/A8WKFG8237+K06aNiDsioEs9BPD/WYQXGihtJGPU7lLU7GITza+P0v8J0CFNmMyRjOJT7NMhc4XfzKUHDhxlrkn6qhYCfiACzj1heqxnlxRvG1z78a+v7idajpQ39LxkiJIFByWJwyEEp1gqnu7FfXhKEEjdAoX2b0DZWlVXiXeacjRkEVL4Aw3oysXorYc4NJaPMeUqa2fzTasJOqZlih+UkeeypfyXz2Uw8JjthLVqvE6xJNVfQrJveAejFTldZP5kj+hKaElr1IVLVISikZ8SFOv/SYEXnow/MmLA7FWcQcDr7Qa7R3NBv9sr+MzvRDnWBHPlnQKXOb+iJbhDcYGm9zmpemGKH61hv6tajMRiJJTKmsKxmbLEcCDTQ42mZInzXC56j0C7ucdfbT5uSjjGbD2zBgCTy0DjMTr1ASgbrgRzaJyRKz6tDyfnC35hvxvSMYpIHi62aIsdUrcQExxl9IOW8vd06Mar5/rtfumQbaO8alyCB3YbfKPCki+75Dq1GiR/kb+N+yC3YKc8dcr8oPu5MzDEIi3xeXbl6ga5Rd0YGcC5Vn8WMrYmOmZeaxRbjQAoix7fP7BipBdS2LBObSFtbwEG/qz+Ae8x58l+thdR0DCv4Rs+loIcIa79QhfeBNd8U9aZpDBAGqM8fIz7BGEphyIsYlg+1Xh3hKf5lYG98qBuVWWFu3Q50+D0N84P/LPtthau8QnrHBWId3jTkpfn0y1X3bDH249kn51P4z7S83EKuaXE1cgjZGakSF1a5mKOR3vhdMayGHUrjcvFxWQsU+uiwdMcFb77Nmn+fD+/eMPo2hNtEPwF7L6GA4k8cmKoZg+3p5cmxroHIEzw68Zgye02fchKA7OkyZ06mK/+I6A8LF3t0bEV1eZL+4hafx1NHlZ27Ya+iUOSxIKRvIghDZF2YWVoKitUS8JSBgukkePqvxL/oV29t4dhmAcfMmNrU9+kncbAOz8rzTl3FtMteY7AivOH10hS/8J8WwWJinRRdtpQzzsXU0+nXG0Xn0NnnKKRchjtZD7Osm6uEbUksg9MNemHHAJJa0/l68fa6V5J1sGMLxcOhHKftpJ3WM1Dj0r/sESBiTzbrvMoPRxoQnZ24wOMoICA2Xu0YHZ+pQoNUM377LjEkIAsM5HWaQbNVfjBY2NV0ek+kv3+w2dnSlvZWmeeAREdnpFissTcB6Rd3H/ozSYEZZNZp1flT4qnG9fMgeyz7scVTgKFEmNBCur8wrHUBxaCtLi2xspt9z836jJJQP4d+bazMZQJTEkHkabav+c7OzASATDJdhYhfFHkl9Rh1/adsxIxUM6GoAkt7WuxHWo1O3HBQMJe254+j1lOYHumS4uEUwEWHE63rH0g1AZssNowU007g5gVtiwT7dU+NNv0R9OKoPclWtG+zjDsSeCkGhd9lC4sZ6CDup7nqqIcPBWIulhdY9xXCsPHuFWK+HlYqU19NSl00kXDQyJbef/PZBrsXrMTLR387emR11MELRi32iekubgqcxQ/fE89f9vKBxEEI4jGYKHh8pcR2G9L0nhDlmyNEDcwqrANH3WoUmTonba793oEtbxjtn+2Q/ooSVz9JoCeOdWH/3GFhiMQN1i7olmUg3gRa88hFlZg+jd4qpED7660qiLRwoE1ylUUQPSSrDwFNkr2tJSyu1yVAmuNWe5w0VL+qO1r2N05w6tcPIBW+26iSp0BnBu8/BO4HM1Gy4FX67wCj8+sBBA6Rl2p4OOzO4ifBI2tUI+rIFRkcIdwteO1gfiiwsWcPo4mg6kFZz3Ll1LTiHpGwnKdEpZsEQSWUNs86A7SJOUxTuTs/zYKTSoY5JKZM0j6oNkahdmmTonQw2nA8KAXjIMLvcxRo0IrLefVx/qH3yXRaSLbnHk6mmFDuPsMlG9lJUsrQ93nW69irRmAlJx7jhq7LTNua+0Qwac5TwDyZaNeTicBOchhenCyxskUS47f6qsSCclSZSTG63TDJS+KF+g30h25iVGf1kIxkHN8mRkghXCBTKjZhldZLzrH10P6YE/K3XluJmfdEdzqjZL/4+zu2uW8o/RR2kNqXqxHdQeoHBrebwjGzrqcuGI4VYapUtz/vs8LOAt+tP2fUkdidxP1BZCB7PgTLxidP/uOTWnUyKhGNWmraGTV58ZAo+mAVZn1XexFeCFQLDkUwnl8zZgTzkc4N9Y7YRnS+EhREHe4zESPxzZKTvDimP0XaYeuEN7ZrnmSGgDIEnzm5vtq1ak6vX8kqfYg4gI2/kjagerd7x0HlUll44VU6YqbVxJxVVDkjFInSi5fGANIgAnIM9AvfzJB1YsUCosZdGm1ICwXMOek7mtsrXQADImqIc/irbJq7jsFlsEMTudfGEHSXjsR+GKt7B/ijqlMMpNNZQHtFFY7YOyWVHHT9Uw0h3U6iLDjEz57411+eKg6zS6Pt1h31ouN4pylE0zG5l6suhDIHBKUKL1Ud/Fj9UwuE51zT0hFiF5UGTux990wlRH8k79hA7hsUjDn13jQYcXq35xhNwp3ywl1uu0pMAgc0jkYN7QrIKxZA8oHECWwQf+vZTv2S+9orbmMdW8AvIgIl4/lOuA1HabNr0FK6F++tgUUN6krco1N2CO+FKz53mg6zbto4+qXTkigEuRtoRdh3iCSj1AdyodcumJmUMfpt6lD/r2PDTVAFvJpdEnrrMbjs+YgnBqe2MX7xW5tEuzpVeVG8Hp9gy2nYwc8BXtkvihw6AbAKn3oQ1MTgGDlr4Nw53MqZcRT+w5+qddqDdTBhAcNacOeBoapCDMB/JJOwjB7xotMtrmCJaMYRdu0YE8IB6qEfGup0Neo0IAOfvkrDzMmzPmgacedAbOhEJW2k3D2l2cgNxMu2tS/7aaN0JRJedthin0Uny85LsVNriGpfzAh707nYe9QQTsYLI8j/4xjjmJSNtT2knh5wvfk/u3E99Ewa2TSwccS63qT2nLV0a56JG/7iFELL9TOvLFyQVxkSvbSDw1EMc+nFveOC12gpPTf7nefaZSybU0Lej2zYSYzy/DyVveZ9TMOtq2NVFtNkew8YosYyiAepzZc/y0kfhQIyY4wDXAL1Y6aQMOsK3bIODhrYmHxxizLucsTGJyzlAlv2hR1dITocsw9AHa9pdwb4lzg7ve9pfxKLAPLSSnCE2dWgxUG9GxrqHmTFF56g7tYWMxSAIHV1PubtVIF2P+eFZ4rgh+matlUcCsrVeYVujQVHgokZOiJ0awlFwqdbNUWpat44m8qnykJ2hNmOH0hWwxhx32xu7QfwrxLC7gJG1+PNwrx+ndt9t7Z4O9DLV/gmrdfZK8VyxWMpw8h6lcnqBiVfZu9lmk3HOHtDXvbD7yUmNuRK/aOdz12d7xuo/c7DtPPM9K72L2xPjutcAFEY9NTt+UuyosfhZzQ+k6cGmk6UYVRzX/fAh5YuIEsNeahUxEWDmoMkcYAHe0zuoIdjZCajEkd1TjdEJNI4QcLZzHo++/w4kkPCDfh6lBup/aZCjq1BRI3THWWl4t1rE8fBjJcUzKoUcTk10HLcVUASM3sOR9wxnEP36YzUHCqwDM02DJWAanhFU51bNPMSXQDfXA/pkMJQkQTRK1rPD+qn19lnQbCo3c6KMOg93YKZ7QHniyaVsa2FnNOuI1BjakbNxxg1cA+1Gn4ExPNXMIGQI1zz4E2yi+8hYGgkCqQuerWgBV6Y00V3KmpiBRRvTJ3/YUpo8V/e26zNZP/L85u9KPJ0Cp4FX+uRz7S+wTkPJ7Qd/XjxHRliglxa3XyIVmgWimdm07l0SZd73WcrzJpCKBe8Xq3Pwdgjcv/532NXH3DHIEXDViiH9v0e1n2ix+pyUUgp0KbMRNpPTrfDFii7SyTp5wQxfcvBll5nEOn1NEVKQYF3Qwa9DlUVHldL4wGee91TPueVJufZOycyzMg0E7U6v8ZgCjZUh2kyunK6P0I77D3dT2eeOjgDYvOCTvMN0xuhd18Zk6yUZJqzCb/TySCClrf1URjt4RJ0jvKq0N2aOOW/5QM6HnPbe5MI+j1fo6oxyF0ZI3C/9zwPyzcgVjLXNAWSjquwO1h4TVewF1JUpkHKTmRz3YQYqmGbh9/cLz8m5pqSIfLfsnmCOFEneIqpkhkHLcvINej4t97j8aYJhkEzdO4dEZs0O5LCfJHq2QmcjRqJdmpmcsuIOnzly/W3VGPTmt3xxCDveLFRteKOayHfDT0s0F0SPsyBGZO6KvO+uK5dRWKB8hmqOxilNVFLyceSQx/vLo3z8WheiDEdNMCNrwnoYbtG8M5UKyzNhPfIzbZ/MJFaRRQUbHly8DF54ZUmybWf9TbeBUxPYzyQe+Q8aVITQX/O85jRjB+gg5kw75ly4v/qoOfd1YI/g0fUsolpCZVkHm3saosKEy0LryieiX0b6JOzR8Vqnp743QWXf8ZPS6LguIhzZqY74NZrrQIKGswD9E8q1/g5IhKce7fes0TkCILLC8d0o+jjEDMMzFZ/35DApj4s9/OBo7XFdj/yx8y0xkeuwPjTsiWs8YjK3dVxe5eM0v/u5/OynoO9Gi0lD2NHaVHCi/IgwjIkEX+PMGNKRcDQDrlaTeTl2UXpnIzSNTeEQccOMRhTDeaN1o1FaDdSduSrMBrxb0MF/vvMvzLe37wzZIv6GCqZT9JmoUvEseY5naee2kqaDVPDBHbZPnVU6EnoLTVYVTIK65Ch/0S2siYtmutw7PPk/sEbmy70J6wNmYGchbtluTt18uJbIDPvfD2McObME3ykEHg7+dHeleBQIh7qO5ZNKLWP4oGIVuJ/nWGekthAK2ENQZjKgPUbIntGZM7t0caZAB94qlb2bPi6k6wKo0J9hyY1wI03e6l4VMQjw3MbOgzuxJHciTJnVMBDmKzqgA6FQgxfNZxVBGmBFFu0ZSUicPYH5L8eTOSipDUoPFwotwgw4/k51pa5q9KvOrNE6JHWAEkiGvjctDCXzIeJ6Uq959hlmn0ShuGeAavNI9dzDGLKzXWKQaNi1xW27eyo0DuCk3Ys4bz/Xa5w2mw+zU0OwR6muEdCJerIBGB6oJTpBcd9XTeFZwfNJ5Hs6jpYlNrnBbJLA4YX0mHVPLeaU0FPnnRkms+6pcV8QwVDnIPo25m0dOlJa2KeMjVPhozueV6s3PkPKx7xjytX3TTmVxDS+jSD6vmfmQ/jZUSx7L1GyLB/bjwWdK3kxVetvEI067XQnebS8Gg/bLO2y+CnuRSEqQue04lG+qEcF/dvTIlBIygV/0Uxn92MvlFzT6Zpl704bkCgfOoxj2qeOTG46HYrl1y6jGC21p/4AI+a+pjcofFIJN5J6b3MIhTAVExSMf1bdANkcHDjoF80uljNh6YaPBJ10Kg375qBceRaRrHXnuXhU+PO1gplbgSglNfMD85pF2RiLYCp2VWdKXIl01CqNTby2W7rsYa40eMOs61RI6uwELF5ihT9c7yFtxc/W3GbbOqL+oeqUdsB7jebcQzxbwpzCxUTqzKlOUA2jzS97SyE/2QHdYZ165Nbl476NEo+PtCfVGIj2WTVUF3jIjyWBP0t+W05sjhHOr0Z4HSPqTgVQ1ut7mltkDoMSqP34rD6MFnM0cv7r7ZjzbBCCOeLVyGIaljeHNXpWhKYZsmCNTX91imJbP+eSV9xLV3OuvT/T6opbQ+04+j24kwhuD7S3CMzj2NxE0j30WKNyp0Zm2rwm8/weQU7DLeCOvLE84/xNPE2TDkfsS8mq+RIy3EhhZWdk6Zwz4GIiscPTV4MHE/3ocuoz3Et4Hi2CdFv2G0uh81DwCzRL0QF+4xxk990HU1WW6VmjmZ+CDRZmvuyatSww8Rajg56yUKzafiAFLBgyPLGf6bvlKFXJ2ZkIIaPx4DCgYy39OP4dtT00xENMUjhuI1aKUSS8+6yzodJB++NtBK2EYisozV2r+5Tq2ecVPW6i2kEyHy8TQXmUc5jkyOgKeBZM3h3Z3GA+BJV/VJg3WUJ7XFF0CaJ1JuloNUMpNdmfGe1VHvtLh1Us9XuCTqPrYpHaNF2ugS0J+Bq+i1T35Dmvk/kcp6lLIVtrch+Dd5H6QlhfyxZVr1Eww1YpZD2St9aSaOYpPUPfMNUod5UDRLoSj5eRBy9RIROQRwrb1K4xORjPr4YypR3s8lkkLuUxFI93Bmx0ylJWDM8r3nAh5f9xSjyiMTONbdl7Y5fBQ2T4s1yCUPGMXEJ7ps41GutFiZCF15+lMqa2KiiXJZ5gUB48hjkKFiGy+XxWPbm4Qj/1tztNM+VjiOAw0TKU/8qBI1gC79nEMz7CDHsqxPR7jpuRz05MIulUIZOwi0yKxTzEzzo191EAQD08HRXkLOpo+MiHJOoyw8KXC+pUUadIL0+/FUrATIOdJ+IUqySk7gU7nCI/ECWWQ1SL/IVZSxmnHLmOqlz7SR9ppNAY3lFXGh26LMih5HUbg+mm+1aD6MTxf8pf25gJ5k5210swalq+tlHoJ8DZOIVZivPvxKL/+38=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Date = _t, #"Total Hours" = _t, Time = _t]),
    ChType = Table.TransformColumnTypes(Source,{{"Date", type date}, {"Total Hours", type number}, {"Time", type time}}),
    AddEndTime = Table.AddColumn(ChType, "End Time", each 
        let 
            totHours = [Total Hours],
            Days = Number.Round( totHours, 0 ),
            remHours = totHours - Days *24,
            Hours = Number.Round( remHours, 0 ),
            remMinutes = (remHours - Hours ) *60,
            Minutes = Number.Round( remMinutes, 0 ),
            Seconds = Number.Round( (remMinutes - Minutes) *60, 0 ),
            Result = [Date] & [Time] + #duration( Days, Hours, Minutes, Seconds )
        in 
            Result, type datetime
    )
in
    AddEndTime

.
With this result
image

.
As for visualizing, you didn’t give much to go on and you need a label but a gantt chart is always nice…

Here’s your sample file
CAL.pbix (99.3 KB)

I hope this is helpful

4 Likes

Thank You @Melissa

This helped.

How do i Pick your M- Brain :innocent: