Timeline for Calculated Field to show difference of hours as value
Current License: CC BY-SA 4.0
12 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Nov 21, 2018 at 7:18 | comment | added | Newbie | My question is how can i make the system calculates totals for field ComputedHours properly that if there are 3 overtime lists i.e. 1:00, 2:30, 1:00...ComputedHours total should be 4.30 or 4.5. | |
| Nov 21, 2018 at 7:17 | comment | added | Newbie | This enables this field/column to be included in the TOTALS and performs the summation. However, this only works if the values of HrsEarned are equal to whole numbers (value), and if there are value like 1.30 (1 hour and 30 minutes), the totals are not calculated properly. I have tried to change the formula to =VALUE(TEXT(HrsEarned,"hh.mm") and values became 0.00...change it to =VALUE(TEXT(HrsEarned,"hh:mm") and values became 1.12. | |
| Nov 21, 2018 at 7:17 | comment | added | Newbie | And lastly another calculated field called HrsEarned is used to sum TotHrs1 and TotHrs2 using the formula =TotHrs1+TotHrs2 The above works properly on the list...but there is a requirement for me to show total of overtime hours of staffs on a monthly basis, and I can only do it when creating a new view as Datasheet View. Since I am unable to get the field HrsEarned in TOTALS...i thought of creating another calculated field called CumputedHours and put the formula =VALUE(TEXT(HrsEarned,"hh"). | |
| Nov 21, 2018 at 7:16 | comment | added | Newbie | Apologies for not making any sense on the initial question...and I will rephrase it. I am trying to make a sharepoint list for Overtime. Basically the overtime form has sections for first 12 hours (00:00 - 12:00) and secondly for (12:00 - 00:00). The fields here are FromHrs1, ToHrs1, FromHrs2, ToHrs2. There are two calculated field TotHrs1 and TotHrs2 that calculates the difference of the above fields to get the number of overtime hours with the following formula =ToHrs1-FromHrs1 and ToHrs2-FromHrs2 | |
| Nov 21, 2018 at 1:51 | comment | added | JoannaW_MSFT | Are they (hours1 and hours2, or "ToHrs1 and TolHrs2") date and time column? You need to provide detail information about your fields. | |
| Nov 20, 2018 at 11:15 | comment | added | Newbie | hi Ganesh...i use a simple addition <!-- =TotHrs1+TotHrs2 --> | |
| Nov 20, 2018 at 10:16 | history | edited | JoannaW_MSFT | edited tags | |
| S Nov 20, 2018 at 10:15 | history | suggested | Ganesh Sanap - MVP | CC BY-SA 4.0 | fixed grammar, improved formatting. |
| Nov 20, 2018 at 10:09 | answer | added | JoannaW_MSFT | timeline score: 0 | |
| Nov 20, 2018 at 9:34 | comment | added | Ganesh Sanap - MVP | what formula you have used for Total hours field please post that. | |
| Nov 20, 2018 at 9:28 | review | Suggested edits | |||
| S Nov 20, 2018 at 10:15 | |||||
| Nov 20, 2018 at 9:22 | history | asked | Newbie | CC BY-SA 4.0 |