I need to record hours in HH:MM in one of the columns of my sheet is there a time format or formula I can use so that entry format is HH:MM . I will not be tracking time in and time out, just the total time worked, for instance, if John Doe worked 7hrs and 20mins, I want to be able to enter 07:20, is this possible?

I would suggest inserting an additional helper column for each HH:MM column. The thread above has a solution for converting HH:MM into a useable number. Then you can sum these helper columns, and there is a solution in the above thread that details how to convert a number back into HH:MM format for display.

Time function

Answers

Ginny Shoemaker ✭✭

05/26/21

@Paul Newcome That explanation actually makes sense! I have a meeting, but then I'm going to follow your instructions and set it up. I will let you know how it works or if I need additional assistance. Thank you very much!🤩

0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Trending in Formulas and Functions

Check a Box if Between Dates on Another Sheet
Hey all, I am trying to build a formula to check off a box on my sheet if at least one date is found between two dates on a separate sheet. I've tried a million variations but here's what I have so far, thinking I was overcomplicating things =COUNTIFS({Approve Date}, >=[Week Starts]@row, {Approve Date}, <=[Week Ends]@row,…
How to Automatically Checkmark a Column for entries that are created within a time-based timeframe
I'm trying to write a formula that will automatically place a checkmark in a checkbox column titled "Today Entry" whenever entries meet the "Created" column criteria of being submitted after 1100 AM the day prior and 0800 AM today on a rolling basis: I've been trying to use the below column, but honestly I have no idea. I…
Calculating the total duration from a date & military time start and end
I have been looking at a lot of information on this site and this is the closest one I have found, however it does not calculate the minutes correctly. For example instead of 8hrs and 45 min it gives me 9hrs and -15min. Formula: =(([On-Site Date]@row - [Notification Date]@row) * 24) + VALUE(LEFT([Time of Crew arrival]@row,…

Time function

Answers

Help Article Resources

Categories