Hours HH:MM format to decimal format

Ask for Help
1

Hello everyone,

I’m building a piece work productivity app where employees enter their time at the beginnig and end of a period, eg. : 13H00 to 17H00 in two time columns and in a third I want do have the time difference so I can use it to calculate their efficiency per hours then.

I’ve tried substrating the two to each other in a math column but it give me akward long strain of numbers.. clearly I can’t make a piece work ratio out of it haha :stuck_out_tongue_winking_eye:

I’d like to know if there is a formula of another computed column to change HH:MM hour format to decimal hour format like this : 13H30 would equal 1,5PM or 13,5.

Thanks in advance :slight_smile:

1 Like
2

hello, i would try this approach:

  1. first, create a “date difference” computed column and ensure the output is in seconds and accuracy is longterm
  2. Then create a “format duration” computed column.. in this, link the date difference column and set the format to something like “hh:mm”
1 Like
3

What column type are you using to store “13H00” or “17H00”?