3.10 PM to 24 hour time please ( 1510 )
Starting from 3:10 PM in A1:
=TEXT(A1,"hhmm")
Or, if you want to use it in calculations,
=VALUE(TEXT(A1,"hhmm"))
--
Kind regards,
Niek Otten
"Steved" wrote in message
...
Thankyou
ok Ive now gone from 3.10 PM to 3:10 PM
I now need to convert it to 24 hour clock please in this case 1510
Thankyou.
"Steved" wrote:
Hello from Steved
Could I have a formula to acheive the below please.
Below is "Text"
3.10 PM to 1510
Thankyou.
|