Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Time to number
Hello from Steved
9:37am to 937 2:20pm to 1420 Please could I have a formula to do the above Thankyou. |
#2
|
|||
|
|||
Hi
=HOUR(A1)*100+MINUTE(A1) and format as General -- When sending mail, use address arvil<attarkon.ee Arvi Laanemets "Steved" wrote in message ... Hello from Steved 9:37am to 937 2:20pm to 1420 Please could I have a formula to do the above Thankyou. |
#3
|
|||
|
|||
How about:
=HOUR(A3)&MINUTE(A3) Hope this helps Rowan "Steved" wrote: Hello from Steved 9:37am to 937 2:20pm to 1420 Please could I have a formula to do the above Thankyou. |
#4
|
|||
|
|||
Thankyou
"Steved" wrote: Hello from Steved 9:37am to 937 2:20pm to 1420 Please could I have a formula to do the above Thankyou. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
avoid retype the number more than one time withen acolumn | Excel Discussion (Misc queries) | |||
How do you enter a negative time number in Excel? | Excel Discussion (Misc queries) | |||
how do i convert a number into minutes for a time of completion c. | Excel Discussion (Misc queries) | |||
convert decimal number to time : convert 1,59 (minutes, dec) to m | Excel Discussion (Misc queries) | |||
Can excel automatically number itself each time you open a documen | Excel Discussion (Misc queries) |