Forum Discussion

DellDelemar's avatar
DellDelemar
Qrew Member
9 months ago

Duration in minutes only

I have a duration formula below: Currently it shows the results in hrs or days. Anyway to have it show hours only and not days? 

var datetime CheckIn = ToTimestamp([Resource Check In Date], [Resource Check In Time]);
var datetime CheckOut = ToTimestamp([Resource Check Out Date], [Resource Check Out Time]);
$CheckOut - $CheckIn



------------------------------
Dell Delemar
------------------------------

1 Reply

Sort By
  • ChayceDuncan's avatar
    ChayceDuncan
    Qrew Captain
    9 months ago

    If the field is already a formula-duration you can change the display from Smart Units to Hours and it will render as the # of hours. If you need the actual value to be a pure # of hours you could convert the field to be formula-numeric and wrap it in ToHours like: 

    ToHours($CheckOut - $CheckIn)



    ------------------------------
    Chayce Duncan
    ------------------------------