View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bikertyke Bikertyke is offline
external usenet poster
 
Posts: 14
Default Summation of time

Why when a try to sum a number of time entries on a spreadsheet who's total
should be around 192 (worked hours per month) does the total appear as 00:00.
This is despite uning the [hh]:mm format, timesing the whole by 24 and
numerous other 'ideas'
Any help greatly apreciated.