Hours and Minutes calculation

Hi,

I am attempting to automate a calculation that will support the conversion of hours to minutes. I have a form the employees enter the amount of time spent with one initiative.

The formula I attempted returns #INVALID VALUE. The value 90 is a manual entry.

Last formula: =TIME([Time Allocation]@row) /60

Time Allocation: Dropdown List (Values):

15m
30m
45m
1hr
1.5hr
2hr
3hr
4hr
5hr

Ultimately, I will create a report that calculates Dawn's total hours per month.

Example: Dawn calculated 240 minutes during the month of July.

Thank you!

Find more posts tagged with

Accepted answers

Mark.poole

@Adarian Searcy

Try this.

=IFERROR(IF(CONTAINS("hr", [Time Allocation]@row), VALUE(SUBSTITUTE([Time Allocation]@row, "hr", "")) * 60, VALUE(SUBSTITUTE([Time Allocation]@row, "m", ""))), "")

This formula searches for an hr in the time allocation column then returns the value multiplied by 60, If hr is not there it will return the value of min. If neither is in the column it returns a blank.

All comments

Mark.poole

@Adarian Searcy

Try this.

=IFERROR(IF(CONTAINS("hr", [Time Allocation]@row), VALUE(SUBSTITUTE([Time Allocation]@row, "hr", "")) * 60, VALUE(SUBSTITUTE([Time Allocation]@row, "m", ""))), "")

Adarian Searcy

Thank you, @Mark.poole this function worked as intended.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.