<div>
You can Format-&gt;Number-&gt;Date and select the one with PM, or Format--&gt;Custom and create one to suit your needs.
</div>


<div>
I can format to AM PM but i need my PM to run from 6pm to 3am and the rest is AM <br />
<br />
Thanks<br />
Seamus
</div>


Seamus2626

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I have time stamps on an excel spreadsheet ranging from midday to 4am e.g 12.01 all the way to 03.50<br />
<br />
I want an if statement to say = if the time stamp is between 10.00 am and 18.00 &nbsp;pm then it returns day time, and anything else = night<br />
<br />
My time stamp looks like = 22/09/2018 &nbsp;00:56:39<br />
<br />
Thanks<br />
Seamus
</div>
</div>


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

If statement for time stamp

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.