Post Reply 
24hr Time Calculations
05-17-2022, 07:55 PM
Post: #5
RE: 24hr Time Calculations
As others have mentioned, the HMS- function is already there, but keep in mind it will return results that are also in HH.MMSS format (meaning you can't sum those directly). You'll need to use the →HR function to convert from HH.MMSS to decimal hours, then you can sum up those results.
Visit this user's website Find all posts by this user
Quote this message in a reply
Post Reply 


Messages In This Thread
24hr Time Calculations - syzygetic - 05-17-2022, 06:18 PM
RE: 24hr Time Calculations - Garth Wilson - 05-17-2022, 07:25 PM
RE: 24hr Time Calculations - Peet - 05-17-2022, 07:38 PM
RE: 24hr Time Calculations - Steve Simpkin - 05-17-2022, 07:44 PM
RE: 24hr Time Calculations - Dave Britten - 05-17-2022 07:55 PM
RE: 24hr Time Calculations - syzygetic - 05-17-2022, 10:01 PM
RE: 24hr Time Calculations - syzygetic - 05-17-2022, 11:56 PM
RE: 24hr Time Calculations - Steve Simpkin - 05-18-2022, 01:29 AM
RE: 24hr Time Calculations - Thomas Klemm - 05-18-2022, 01:27 AM
RE: 24hr Time Calculations - Peet - 05-18-2022, 07:55 AM
RE: 24hr Time Calculations - syzygetic - 05-18-2022, 03:10 AM
RE: 24hr Time Calculations - syzygetic - 05-18-2022, 11:34 AM
RE: 24hr Time Calculations - Thomas Klemm - 05-18-2022, 08:35 PM
RE: 24hr Time Calculations - syzygetic - 05-19-2022, 02:21 PM
RE: 24hr Time Calculations - Thomas Klemm - 05-19-2022, 03:11 PM
RE: 24hr Time Calculations - Thomas Klemm - 05-22-2022, 12:34 PM



User(s) browsing this thread: 1 Guest(s)