summing by date

Hi have a list of dates and times with a number (hours worked) next to them, please see attached excel sheet.
I'd like to add the time per week, perhaps specified by the user.
Is this possible with functions or do I need a macro. I was thinking of a combination of sumif and the date function but I'm not sure if the date fuction will work with the date format I have in column A.

Thanks

Jon

The sample you give is all text/values...

How is the date entered? As a manually-entered numeric using a date format? As a string from an external application?

If the latter, it would probably be easier to change the source date format - if that's feasible.

The time suffix introduces a content variable that would play havoc with matching and the leading zero-suppression on day and month numbers doesn't help either.

The leading "Day" value seems fixed length at 3 characters, so is a not a challenge to strip off.

Ideally, if source of data is another Excel sheet, ensure that both source and destination date columns share the same Excel data format and bring in that date as an Excel date. Then you chop it up into Year, Month and Day if you need to obtain totals by day, month and/or year.

Sorry...

Dave

It's copied from outlook journals

Thanks