Duration between Military Time

Brittany Hajicek · 2020-01-21 17:21:33

What is the easiest formula to use to determine the time difference between two Military Times? I'm using the 4 digit military time and also I need the formula to calculate across midnight. I'd like the time difference to be in minutes (but that can be done in a separate column formula). I know @Paul Newcome has skills…

Answers

PJ Beaudry ✭✭✭

06/21/23

@Paul Newcome You are a magician

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

VLOOKUP or IF?
Hello, I am not sure if I should be using VLOOKUP or an IF/THEN statement or a combination of the two. Any help is greatly appreciated. Thank you. Problem Statement: I want the PWS link to auto populate based on the Areas of Support selection. Both columns are dropdowns. Current attempt gives me a circular reference.…
Populate Status Based on Children
I need a formula that will auto populate the status of a parent task based on its children's statuses. If all children have the status "Not Started", the parent should reflect "Not Started". If any children have the status "In Progress", the parent should reflect "In Progress". If all children have the status "Complete",…
How to perform "IF(ISNA(VLOOKUP.." or "IF(ISERROR(MATCH.." when there are multiple items in cell
The sheets I have: Hospital Notification Survey Form - where Regional Directors attest that they have notified one or more hospitals of the upcoming change (for simplicity, I'll say there's 10 total hospitals) Hospital Notification Tracking Sheet - will track submissions from the above survey form's sheet, which ultimately…

Duration between Military Time

Answers

Help Article Resources

Categories