View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
p45cal[_39_] p45cal[_39_] is offline
external usenet poster
 
Posts: 1
Default Calculating Phone Bills Help Please


Times are held in excel as fractions of a day.
Converting the .12/minute to a /day value comes to 172.8/day
(That's 60*24*0.12)
Now multipy each time by 172.8 then add 0.02, not forgetting to format
the result cell as currency in case it wants to display as a date.
(I've assumed they charge pro rata for fractions of a minute rather
than in increments of 1 minute)


--
p45cal

*p45cal*
------------------------------------------------------------------------
p45cal's Profile: http://www.thecodecage.com/forumz/member.php?userid=558
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=126934