Thread
:
3.02 PM ( Decimal Point )to 1502
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
Steved
Posts: n/a
3.02 PM ( Decimal Point )to 1502
Hello from Steved
From 3.02 PM to 1502 Military time please.
The below formula is my attempt but displays #VAULE!
HOUR(B71)*100+MINUTE(B71)
Thankyou.
Reply With Quote
3.02 PM ( Decimal Point )to 1502