Link to home
Create AccountLog in
Avatar of Seamus2626
Seamus2626Flag for Ireland

asked on

If statement for time stamp

Hi,

I have time stamps on an excel spreadsheet ranging from midday to 4am e.g 12.01 all the way to 03.50

I want an if statement to say = if the time stamp is between 10.00 am and 18.00  pm then it returns day time, and anything else = night

My time stamp looks like = 22/09/2018  00:56:39

Thanks
Seamus
Avatar of Martin Liss
Martin Liss
Flag of United States of America image

You can Format->Number->Date and select the one with PM, or Format-->Custom and create one to suit your needs.
Avatar of Seamus2626

ASKER

I can format to AM PM but i need my PM to run from 6pm to 3am and the rest is AM

Thanks
Seamus
ASKER CERTIFIED SOLUTION
Avatar of Norie
Norie

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account