Skip to main content
Solved

Manual Time tracking in 15 min intervals (calculation/formula support)

  • February 22, 2023
  • 4 replies
  • 52 views
D
Forum|alt.badge.img+4

Hi all, 

Hoping someone can help. I'm trying to create a time sheet where the user inputs the hours & minutes they worked in 15min increments - so 1.25 (1 hour 15 mins), 1.5 (1hr 30 mins) etc.

How do I get this to appear as 1hr 15 mins, 1hr 30 mins in an hh:mm format without asking them to do their time sheets in seconds and also have the ability to roll up the totals?

Ideally they would not be tracking start end times using date fields. Just a box yo input a decimal. 

Example: 

 

This is a platform I've used for timesheets in the past, Synergist

 

Thank you!

Best answer by TheTimeSavingCo

Darcie_Tanner1 wrote:

Thanks @Ron_Daniel. I think I was trying to work out the most efficient way to type it, so a decimal vs a colon - but maybe I’m using my habits too much as a standard approach.

 

just thinking if they have to do many of these a day it might be cumbersome, but that’s using a keyboard with a keypad. Most will probably be on laptops & mobile, so may not be an issue as much.


Hm, if it's just about display you could use this:

 

IF( Number, IF( ROUNDDOWN(Number, 0) > 0, ROUNDDOWN(Number, 0) & "hr " ) & MOD(Number * 60, 60) & " mins" )

Resulting in:

And you could then rollup on "Number" with the same formula setup, ending up with:

Link to base

 

View original
Did this topic help you find an answer to your question?

4 replies

Ron_Daniel
Forum|alt.badge.img+19
  • Ron_Daniel
  • Inspiring
  • 104 replies
  • February 22, 2023

@Darcie_Tanner1  you may be able to do this using the Duration field. They would have to enter in hours and minutes, not as a decimal. In other words, an hour and a half they would enter as 1:30, not 1.5. These are easy to roll up in totals as well:


D
Forum|alt.badge.img+4
  • Darcie_Tanner1
  • Author
  • Participating Frequently
  • 5 replies
  • February 22, 2023
Ron_Daniel wrote:

@Darcie_Tanner1  you may be able to do this using the Duration field. They would have to enter in hours and minutes, not as a decimal. In other words, an hour and a half they would enter as 1:30, not 1.5. These are easy to roll up in totals as well:



Thanks @Ron_Daniel. I think I was trying to work out the most efficient way to type it, so a decimal vs a colon - but maybe I’m using my habits too much as a standard approach.

 

just thinking if they have to do many of these a day it might be cumbersome, but that’s using a keyboard with a keypad. Most will probably be on laptops & mobile, so may not be an issue as much.

Ron_Daniel
1 person likes this
  • Ron_Daniel
    Ron_Daniel
TheTimeSavingCo
Forum|alt.badge.img+28
Darcie_Tanner1 wrote:

Thanks @Ron_Daniel. I think I was trying to work out the most efficient way to type it, so a decimal vs a colon - but maybe I’m using my habits too much as a standard approach.

 

just thinking if they have to do many of these a day it might be cumbersome, but that’s using a keyboard with a keypad. Most will probably be on laptops & mobile, so may not be an issue as much.


Hm, if it's just about display you could use this:

 

IF( Number, IF( ROUNDDOWN(Number, 0) > 0, ROUNDDOWN(Number, 0) & "hr " ) & MOD(Number * 60, 60) & " mins" )

Resulting in:

And you could then rollup on "Number" with the same formula setup, ending up with:

Link to base

 

Adam, Consultant @ The Time Saving Co
Ron_Daniel
D
2 people like this
  • Ron_Daniel
    Ron_Daniel
  • D
    Darcie_Tanner1
D
Forum|alt.badge.img+4
  • Darcie_Tanner1
  • Author
  • Participating Frequently
  • 5 replies
  • February 23, 2023
TheTimeSavingCo wrote:

Hm, if it's just about display you could use this:

 

IF( Number, IF( ROUNDDOWN(Number, 0) > 0, ROUNDDOWN(Number, 0) & "hr " ) & MOD(Number * 60, 60) & " mins" )

Resulting in:

And you could then rollup on "Number" with the same formula setup, ending up with:

Link to base

 


Ooooh - interesting - thank you!

TheTimeSavingCo
1 person likes this
  • TheTimeSavingCo
    TheTimeSavingCo

Reply


Most helpful members this week

Terms & Conditions