Starting Week number by specific time

Hi

Is there a formula to work out date/time range so the week starts and ends on a specific time? I want to start a week from 6am and ends at 6am by week end.

Thanks

if you upload a sample it will most likely be easier to assist. sounds like you could simply subtract .25 from your date range in the weeknum formula

Formula:

=WEEKNUM(A2-0.25)

where your date is in a2.

Hi


Thank you for the help so far.

I have 2 columns A contains the date, B is the time and C is the Week Number. I would like to start a week where the time starts at 6am on a Sunday and finish the following Sunday at 6am.


A B C
14/09/2014 23:28:18 37
14/09/2014 23:28:18 37
14/09/2014 23:41:20 37
14/09/2014 23:48:05 37
15/09/2014 00:25:51 38
15/09/2014 00:35:02 38
15/09/2014 01:14:42 38
15/09/2014 02:28:03 38


I've used =WEEKNUM(A2-0.25,1) but unsure how to integrate the formula with column B as well.

Thanks

I have used the following formula which has worked. Thanks!!

=WEEKNUM(A2+(B2-0.25),1)