Count between Date & Times

[Steven1985]

Hi,

I have Column A the Date and Time e.g. 01/09/2011 10:09:00

I will manually input on Column AP the manual date e.g. 02/09/2011 12:10:00

I need a formula in Column AQ to count the above 1 Day. 2hours, 1 mins.

Is this possible?

Thanks

 

[VoG]

Try

=AP1-A1

Format as Custom

d hh:mm

 

[Steven1985]

Thats great thanks,

How would I say if cell AP is Blank then AQ display is blank and also I have a list of 'non-working days' on the 'control tab' Column A10-A47 to only count working days.

Is there a way to link all this in?

Thanks

 

[VoG]

Try

=IF(AP1="","",AP1-A1)

Sorry, I don't know about the non-working days. If somebody doesn't reply to that in a while try starting a new thread as it is a somewhat different question to your original.