Copy link to clipboard
Copied
Hi There,
I'm trying to create a timesheet in Adobe, but HR requires that the hours be submitted in decimal format rounded to the nearest quarter (ex. 1 hour 30 minutes of work is ti be submitted as 1.5.) However, the times nust be entered in H:MM tt format. Picture included for reference.
Any ideas/solutions?
Thanks,
Tim
Copy link to clipboard
Copied
In the past, I used a way to count for 100 minutes per hour then convert it back to 60 to display results.
Copy link to clipboard
Copied
How did you do that?
Copy link to clipboard
Copied
Copy link to clipboard
Copied
Thanks, but this didn't get me any further.
All I need is for 1h 30m to return as 1.5h
Copy link to clipboard
Copied
In your calculation just divide minutes by 60 and then add result to hours,
Copy link to clipboard
Copied
I don't understand what you mean, I'm sorry.
Copy link to clipboard
Copied
All I need is for 1h 30m to return as 1.5h
To get decimal from time, divide minutes by 60, you need to implement this into your script where you calculate total time.
Find more inspiration, events, and resources on the new Adobe Community
Explore Now