View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ward376 ward376 is offline
external usenet poster
 
Posts: 360
Default How calculate difference between [t]:mm-format and general format

Enter the 80 as hours - 80:00.

Dates and times in Excel are just formatted numbers. Dates to the left
of the decimal and times to the right.

80 hours = 3.33333333333333 (3 and 1 third days)

Excel won't display negative time/date values. (######) Make sure you
subtract the larger from the smaller if you're going to display the
result as a time/date.

Cliff Edwards