One issue I can see is that in your problem foreach statement, you use a constant 'HourSignIn' to access your nested hash structure. However, Data::Dumper is indicating that there's no such hash key, but there are hash keys such as 'HourSignIn13', 'HourSignIn12', 'HourSignIn10', etc.

Hey - what's going on - there are weird characters in there between the 'In' and the digits! What's with the funny stuff?!

Ah - that's what the post about character \034 (0x1C) was on about... I think I've just caught up with the conversation here!

So, to re-address the problems you're seeing, avoid using a => in a hash key, ie

$ClubTotal{ 'DayOfMonth' => $date }...
[download]

because Perl does give that some meaning, but it's almost certainly not the meaning you want! Instead I think you need:

$ClubTotal{'DayOfMonth'}{$date}...
[download]

This will allow you to iterate over the items in the nested hash:

foreach my $date (%$ClubTotal{'DayOfMonth'}) { ... }
[download]

Hope that points you in a useful direction.

Welcome to Perl :-)