Changing a date and time to named day, date and rounded down hour

Hi there

I want to convert a date and time in cell A2 in dd/mm/yyyy hh:mm format to the following:

B2 - Day - i.e. Monday, Tuesday etc
C2 - Date in two digitals - i.e. 10
D2 - Month is two digitals - i.e. 10
E2 - Hour in two digits rounded down - i.e. 11 for 11:38

The columns need to have numerical digits and not date and time converted to just show day etc.

See attached sheet.

Many thanks in advance.

Try

B2: =TEXT(A2,"dddd")
C2: =DAY(A2)
D2: =MONTH(A2)
E2: =HOUR(A2)

Hope that helps.

Thanks Jonmo1. Super quick response. All works well. Only one slight problem. If column A is blank, column B returns a date of Saturday. Any ideas?

Try

=IF(A2>0,TEXT(A2,"dddd"),0)

Brilliant. Tweaked it slightly to return nothing =IF(A2>0,TEXT(A2,"dddd"),"").

Thanks so much.

Great, glad to help.