-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
DAX Formula Help
- Thread starter Aliq2014
- Start date
Excel Facts
Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand
olivierhbh
Board Regular
- Joined
- Jun 22, 2015
- Messages
- 136
Hi Aliq,
Can you try this formula below?
Basically, we search the position of ":", multiply what's on its left by 60 and add it to what's on its right (+0 converts both parts into numbers).
Can you try this formula below?
Basically, we search the position of ":", multiply what's on its left by 60 and add it to what's on its right (+0 converts both parts into numbers).
Rich (BB code):
=
( LEFT ( [times], SEARCH (":", [times] ) - 1) + 0 ) * 60
+ RIGHT ( [times], LEN ( [times] ) - SEARCH (":", [times] )) + 0
Upvote
0
Similar threads
- Replies
- 5
- Views
- 380
- Replies
- 1
- Views
- 216
