View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default Formula for showing items per minute

Excel times aren't stored as minutes, but as days.
60*24 = 1440.
--
David Biddulph

"PoppaButch" wrote in message
...
Hi,
I have been trying to come up with a formula where the end result would
show
how many items per minute.
a1= 120 widgets (# is formated as number)
b1 = 120 minutes(# is formated as [m])
conventional wisdom would tell you b1/a1 = 1 widget per minute
I come up with 1440.
What am i doing wrong?