This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

How to extract only minutes from a DateTime field

Posted on 05-05-2025 11:05 PM
Grover426
Bronze 2
Bronze 2
Reply posted on --/--/---- --:-- AM

Please if you could help me, I tried to use this expression TEXT([Date],"MM") to get minutes but I only get the month number, how could I do it, I would be very grateful.

Solved Solved
0 2 117
Topic Labels
Jump to Solution
0 Likes
1 ACCEPTED SOLUTION

Posted on --/--/---- --:-- AM
Suvrutt_Gurjar
Platinum 2
Platinum 2
Reply posted on --/--/---- --:-- AM

Please try 

MINUTE(TIME([Date])-"00:00:00")

 

View solution in original post

Jump to Solution
2 REPLIES 2

Posted on --/--/---- --:-- AM
Suvrutt_Gurjar
Platinum 2
Platinum 2
Reply posted on --/--/---- --:-- AM

Please try 

MINUTE(TIME([Date])-"00:00:00")

 

Jump to Solution

Posted on --/--/---- --:-- AM
Grover2
Bronze 3
Bronze 3
Reply posted on --/--/---- --:-- AM

Thank you very much Suvrutt_Gurjar, it worked, I appreciate it.

Jump to Solution
Top Labels in this Space