Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Posted: 20 Nov 2009 at 9:53am
The only way I could thing you could do is to make a formula to first do a date difference of the date part, then do a date difference on the time part and concate them together (convert to text first).
Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Posted: 24 Nov 2009 at 12:50pm
Well this seems to work pretty well, of course it there is an issue with getting negative numbers in the time portion. I would have to do further research to get the time value converted to a number as a whole then do the subtraction.
Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Posted: 25 Nov 2009 at 9:26am
Thought about it and you would need to take the minute values and multiply by 60 (before subtracting), take the hour values and multiply by 3600, add the second's value + minute's value + hour's value (do all the above for the both the datetime1 and datetime2). Then subtract the two values. Then you would need to do the mod of both the values to break it back into hours, minutes and seconds.
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 25 Nov 2009 at 9:40am
Can you define this more clearly? You state you want this in Month Day Hour Minutes, but how are you defining a month? Your example "i.e. 11/18/09 03:54:00 - 11/19/09 05:00:00 = 1 01:06:00" is easy to understand but what about something like...
"11/18/09 03:54:00 - 11/17/09 02:53:00" ?
The month component is not as easy to define here as month lengths are not consistent.
Please define this exactly and it would be easier to assist.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum