- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
Re: Adding Duration to a Start time to achieve a time value
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
03-18-2017 04:18 PM
A function like TIME or TIMEVALUE for duration perhaps?
Re: Adding Duration to a Start time to achieve a time value
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
03-18-2017 07:22 PM
Well, the picture explains a lot.
First of all, your numbers of seconds are much more than something like a few hours (or a part of it, as in your original example), so it doesn't make sense to add it to a time without date, unless you acually want to start at December 30, 1899, 7:00 AM.
(Date numbering in the Power.... environment is based on the numbering in Excel starting with 1 on 1/1/1900, but unfortunately the year 1900 was considered a leap year.... so day 60 in Excel is the non existing 2/29/1900; day 61 is 3/1/1900 both in Excel and the Power ... environments, so calculating back to 0 brings you to December 30, 1899, 12:00:00 AM (midnight)).
If you are adding a number to a datetime as a new column, then you are adding days.
So if you want to add seconds, you need to divide the number by the number of seconds in a day, being 86400 (24 * 60 * 60).
Your example of 1,555,200 seconds brings you to 1/17/1900 7:00:00 AM.
Watch this video, to which I added a short demo of Camtasia Studio, the software I'm using to create videos.
Re: Adding Duration to a Start time to achieve a time value
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
03-18-2017 07:36 PM
And it will break down to showing the correct time from that?
Re: Adding Duration to a Start time to achieve a time value
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
03-18-2017 07:48 PM
Add a date to your Start.
Re: Adding Duration to a Start time to achieve a time value
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
03-19-2017 01:51 AM
After reading over and over it again and again (I just wasn't getting it); I finally understood that I was using the seconds column, instead of the days column which was causing me to stand still when it came to my plus column.
Thank you so much, I really appreciate, it really does mean a lot to me.