Home » Forums » News » ExcelExperts News

Calculate Business Date & Time

Submitted by Durgaprasad on 13 June, 2013 - 21:21

Hello,

I need to capture Business Date & Time in Excel.

For example if am doing night shift starting 25/01/2013 6.30 pm and ending 26/01/2013 3.30 am then I need to capture date as 25/01/2013 whenever I click something between this time....

Thanks in Advance for your help...

‹ rank calculation Excel Experts Rating ›
»
Nick's picture

take the INT of the start

Submitted by Nick on 13 June, 2013 - 22:27.

take the INT of the start date

i.e. if 25/01/2013 6.30 pm is in cell A1, use this formula in B1:
=INT(A1)

»