Change Time into Military
Answers
-
It worked but now I'm getting an extra number on every row, even the ones that are not three digits.
So instead of 5 hours is giving me 50 and for 5.5 is giving me 59.5.
=(VALUE(LEFT([End Military]@row, IF(LEN([End Military]@row) = 3, 1, 2)) + VALUE(RIGHT([End Military]@row, 2)) / 60) - (VALUE(LEFT([Start Military]@row, IF(LEN([Start Military]@row) = 3, 1, 2)) + VALUE(RIGHT([Start Military]@row, 2)) / 60)))
-
@Adrian Garcia Are you able to provide a screenshot of the time columns?
-
Here is the formula I'm using for military time:
=VALUE(IF(VALUE(LEFT([Demo Start Time]@row, FIND(":", [Demo Start Time]@row) - 1)) <> 12, VALUE(LEFT([Demo Start Time]@row, FIND(":", [Demo Start Time]@row) - 1)) + IF(CONTAINS("p", [Demo Start Time]@row), 12), IF(CONTAINS("p", [Demo Start Time]@row), 12, 0)) + MID([Demo Start Time]@row, FIND(":", [Demo Start Time]@row) + 1, 2))
-
I'm not sure why it is doing that. Try this one with a couple of extra parenthesis tucked in to help isolate certain pieces.
=(VALUE(LEFT([End Military]@row, IF(LEN([End Military]@row) = 3, 1, 2)) + (VALUE(RIGHT([End Military]@row, 2)) / 60)) - (VALUE(LEFT([Start Military]@row, IF(LEN([Start Military]@row) = 3, 1, 2)) + (VALUE(RIGHT([Start Military]@row, 2)) / 60))))
-
Same result but thanks for your help, atleast the negative values are gone. I'll keep working on it to see if I can find a solution that would get rid of that problem.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives