View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MJW[_2_] MJW[_2_] is offline
external usenet poster
 
Posts: 39
Default Duration in Hours (or hh:mm:ss)

Hi All,

I'm currently trying to create a column in a sheet which calculates the age
in hours (or hours and minutes, though hours is optimal) that have elapsed
since the date/time stamp in the column which proceeds it. Is there any way
to manage this outside of a VBA solution? I'm about as green as it gets when
it comes to VBA, and I'm sort of surprised to find that there isn't a
standard function (like datedif) which supports this. Any help would be
greatly appreciated.

Thanks

Jamie