View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Yanick Yanick is offline
external usenet poster
 
Posts: 23
Default convert time to decimal

On Jan 13, 10:35*am, doodle302
wrote:
I'm looking for a formula to convert time to a decimal

Example: (6:15 + 5:45 + 2:15 + 1:25) * 3 = equals amount due in dollars
(whole number)

times listed are for different days


Use cell format [h]:mm:ss

23:00 + 6:00 will = 29:00