Re: Average start time handling midnight

There are date functions that will just give you the elapsed time. They should even be able to account for different timezones. http://search.cpan.org/~drolsky/DateTime1.34/lib/DateTime.pm#Datetime_Subtraction Another option is to convert the dates to unix time and subtract, then figure out how many hours, minutes and seconds elapsed. This is a great place to just use a library rather than build something new.

Comment on Re: Average start time handling midnight

Replies are listed 'Best First'.
Re^2: Average start time handling midnight by hippo (Archbishop) on Jul 22, 2016 at 08:47 UTC
It would indeed be a trivial exercise if the date information were available as well as the time of day. However, there's no indication at all in the OP that the date information is present in the data set and that is why it has garnered responses which are as varied as they are many. BTW, the URL you included gives a 404, perhaps you meant http://search.cpan.org/~drolsky/DateTime-1.34/lib/DateTime.pm#Datetime_Subtraction?	[reply]

Replies are listed 'Best First'.

Re^2: Average start time handling midnight
by hippo (Archbishop) on Jul 22, 2016 at 08:47 UTC

It would indeed be a trivial exercise if the date information were available as well as the time of day. However, there's no indication at all in the OP that the date information is present in the data set and that is why it has garnered responses which are as varied as they are many.

BTW, the URL you included gives a 404, perhaps you meant http://search.cpan.org/~drolsky/DateTime-1.34/lib/DateTime.pm#Datetime_Subtraction?

[reply]