ninteen83
asked on
Dividing total minutes into hours & minutes
a form has 3 fields
From_Time [Date/Time]
To_Time [Date/Time]
Total_Minutes [Text - Computed]
@Integer((To_Time-From_Tim e)/(60))
In a view, I've inserted a column for Total_Minutes. I've selected "Total" under "Totals:" in the 'sorting' tab of the column. This works fine.
Is there any way to divid the minutes of each row/document into hours then minutes. like for 150 minutes, it should show "2 hours 30 minutes" or "02:30" or similar to that
I hope my query is clear to you all. Thanks in advance
From_Time [Date/Time]
To_Time [Date/Time]
Total_Minutes [Text - Computed]
@Integer((To_Time-From_Tim
In a view, I've inserted a column for Total_Minutes. I've selected "Total" under "Totals:" in the 'sorting' tab of the column. This works fine.
Is there any way to divid the minutes of each row/document into hours then minutes. like for 150 minutes, it should show "2 hours 30 minutes" or "02:30" or similar to that
I hope my query is clear to you all. Thanks in advance
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hemanth !
what does @Text(@Integer((diff - (@Integer(diff/86400)*8640 0)) /3600)) do ??
by taking the diff. of From_Time and To_Time, I'm able to take out the hours and minutes. I'm using the following formulas :
for hours : @Abs(@Integer((To_Time -From_Time)/(60*60)))
for minutes : @Modulo(Total_Minutes;60)
I'm not sure whether screenshots are allowed in the forum or not: see the following image.
http://www.qewc.com/procurement.nsf/0/45f59ddbe9467a8c43256f54001d4da2/$FILE/lotusnotes.gif
I've created several documents. I'm able to take the correct duration for each document. e.g. 6 hours, 30 minutes
the above view has 2 column Hr and Min; Hr is set to take Total of Hours (of multiple docs) and Min is set to take the total of minutes
in the picture, under PROJECT TRACKING SYSTEM .. it has given [12 75]
I want it to display 13 hours 15 minutes for PROJECT TRACKING SYSTEM not 12 hours 75 minutes
is this possible ?
what does @Text(@Integer((diff - (@Integer(diff/86400)*8640
by taking the diff. of From_Time and To_Time, I'm able to take out the hours and minutes. I'm using the following formulas :
for hours : @Abs(@Integer((To_Time -From_Time)/(60*60)))
for minutes : @Modulo(Total_Minutes;60)
I'm not sure whether screenshots are allowed in the forum or not: see the following image.
http://www.qewc.com/procurement.nsf/0/45f59ddbe9467a8c43256f54001d4da2/$FILE/lotusnotes.gif
I've created several documents. I'm able to take the correct duration for each document. e.g. 6 hours, 30 minutes
the above view has 2 column Hr and Min; Hr is set to take Total of Hours (of multiple docs) and Min is set to take the total of minutes
in the picture, under PROJECT TRACKING SYSTEM .. it has given [12 75]
I want it to display 13 hours 15 minutes for PROJECT TRACKING SYSTEM not 12 hours 75 minutes
is this possible ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
The totals line will never display in a correct format, if there is seconds to minutes overflow. Not if you do it my way, not if you do it Hemantha's way. At least, not up to version R6.0.3. In my case, totals will never display as a time-value unfortunately.. As for splitting the hours and minutes in two different counters: you'll never know the overflow from the minutes to the hours. It is strange that the format of the totals value cannot be defined. I think that's a serious Notes mistake.
ASKER
---
It is strange that the format of the totals value cannot be defined. I think that's a serious Notes mistake.
---
:) you are right sjef_bosman .. IBM should be asked for this.
my question was not solved and I don't think there is a solution for that. don't want to take back my points .. "eik baar jo diya - so diya" ;) .. I'm dividing it between both of you
thanks for the help.
It is strange that the format of the totals value cannot be defined. I think that's a serious Notes mistake.
---
:) you are right sjef_bosman .. IBM should be asked for this.
my question was not solved and I don't think there is a solution for that. don't want to take back my points .. "eik baar jo diya - so diya" ;) .. I'm dividing it between both of you
thanks for the help.
Thanks for points.
Asking IBM is like saluting the moon... pretty pointless.
Asking IBM is like saluting the moon... pretty pointless.
Without trying whether the code works (I don't have the time at the moment):
- create a column with value
@Time(0; 0; To_Time-From_Time)
- display the column with Time-only.