Elwyn Roberts

1. Community
2. Questions & Answers

To calculate the number of seconds between two dates, I am using the TIMESTAMPDIFF function (only if there is a start datetime).IF(ISBLANK(#Start), 0, TIMESTAMPDIFF("SECOND", #Start, #End))For some...

• Elwyn Roberts
• April 25, 2023 21:17
• 3 followers
• 7 comments
• 0 votes

1. Community
2. Questions & Answers

We have an excel file that we import.  One particular column sometimes does not have any values in it (so its null).  If the first x number of rows being imported are null, then the import "skips" ...

• Elwyn Roberts
• January 06, 2022 15:31
• 3 followers
• 8 comments
• 0 votes

1. Community
2. Questions & Answers

We have a column for comments.  People can tag important info in this string field using a # and code for the Start date, end date, 3rd party system, Work effort in hours.  So a string value is inc...

• Elwyn Roberts
• August 17, 2021 15:31
• 3 followers
• 18 comments
• 0 votes

1. Community
2. Questions & Answers

I have a column which holds the date but as a string.  Its in GMT so I need to convert it to EST as well.  The original date as string, looks like this:     14-SEP-19 05.06.25.734000 PM Before I ca...

• Elwyn Roberts
• September 18, 2019 14:45
• 2 followers
• 4 comments
• 0 votes

1. Community
2. Workbooks & Analytics

I have pulled in a dataset which has the employee login which should be 6 numerics.  However, the data includes some nonnumeric characters (maybe contractors?) and so the column is STRING and not I...

• Elwyn Roberts
• April 14, 2018 22:10
• 5 followers
• 5 comments
• 1 vote