Salesforce IdeaExchange
- then -
Apex and Visualforce Comments
| Apex and Visualforce Ideas
|
Force.com Platform Comments
| Force.com Platform Ideas
|
Administration & Sharing Comments
| Administration & Sharing Ideas
More Precise Time Functionality
I wanted to create add a formula field that adds a "Start Time Field" and a "Duration" field to get an end time field. The duration is the number of minutes
So I've got a formula like this:
Start_Time__c + ( Duration__c / (1440) )
This doesn't quite work right though -- there are enough rounding errors that if I have a Start Time of "12:30" and a Duration of "60", I'm getting a result of 1:29 -- and not 1:30.
I'd like to be able to add 60 minutes -- and not a fraction of a day like I'm doing here.
I can't find enough flexibility in the time functions in order to do that.
|
michaellee 04/17/08 |
I've even noticed that the calculated time differs depending on where I am looking at it -- in a view, it's one minute later than it is on a page. |
track comments for this idea
Please log in to post a comment
recently promoted by:
- newbster
- michaellatideas
- Francesco23
- 10/10/2007_5:51
- michaellee
POST IDEA