Date Calculations

4 Topics

SharePoint Online Date Calculation
I'd like to calculate the number of days between [today] and the due date in a SharePoint Online task list. Not sure why this seems so difficult or why I can't readily find an answer online. Any ideas? Thanks so much ahead of time for your help.
Cindy Zalme
Jan 31, 2023 Place SharePoint
17KViews
0likes
16Comments
Training System
I created the training booking system using Sharepoint List with date selection. I wanted on each day, once the number of booking reached to 20 Message will appear that is session is full you can register the training other days. With limitation of Weekends. Any Validation formula, Presave JavaScript. Thanks In advance.
Zaheer_Abbas
Jan 05, 2022 Place SharePoint
720Views
0likes
0Comments
Convert multiple combinations of date text strings into a seconds
Hi everyone! Maybe someone can help me with this problem... I'm using a software to manage telemarketing campaigns. This software allows me to create several informs and one of them is to know of much time an operator is logged in a campaign. The problem is that the output is in text format and with multiple combinations such as: - 2d19h20m55s - 4h58m56s - 15h37m5s - 21m55s - etc. My goal is to create a function that can convert all of this possible combinations in seconds. I started with this =+LEFT($C4;FIND("d";$C4;1)-1)*24*60*60 but now I'm stocked. Is it that possible or I have to create a function for any possible combination? Thanks in advance.
Solved
Daniel Martínez León
Aug 06, 2018 Place Excel
2.2KViews
0likes
3Comments
Excel- 11/13/2017 10:01 PM to display as - 11/13/2017 22:01:00
using excel 2007 I want my date - 11/13/2017 10:01 PM to display as - 11/13/2017 22:01:00 I tried text(), datevalue() but no luck. can someone help ?
Swati Pathak
Jul 25, 2018 Place Excel
1.2KViews
0likes
1Comment