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

If Statement Help
I could really use some help! I am trying to write an if statement. Based on: Due date being < = -68 New entry is "starred" Entry 1 = "yes". I want it to be complete if it meets the conditions listed above and incomplete if it doesn't meet those conditions. This is what I tried: =IF([New Entry]@row = 1, [Entry 1]@row,…
can i use sumif formula with my criteria referencing a cell in my sheet?
Hi Im trying to create a formula that pulls a sum from different sheet when the criteria matches a cell in my current sheet- is this possible? i get invalid operation when i try…
Countifs, with a cross reference and an or
Hi there, I'm trying to count how many red risks I have in my RAAIDD log that are not closed or complete. I've written the below, but I can't get it to work. Any advice would be gratefully received, please. =COUNTIFS({NAME RAAIDD Range 1}, "Risk", {NAME RAAIDD Range 3}, ">=8", {NAME RAAIDD Status}, OR(@cell = "Open", @cell…

Time function

Answers

Help Article Resources

Categories