PPRuNe Forums > Misc. Forums > Computer/Internet Issues & Troubleshooting > Excel Time Calculation PDA View Full Version : Excel Time Calculation Maxflyer29th Jul 2005, 10:28I need to divide an amount of hours, minutes and seconds by a value to get a per minute rate. I can't get it to work. I'm a complete thicko with MS Excel. Can anyone help? Thanks in advance. MF MadsDad29th Jul 2005, 11:38Format the cells with the cells (say column a) as a number and the cells with the time as 'hh:mm'. So we then have, say, column A formatted as num, 2 dec, and column b as hh:mm. In column c row 1 (or wherever) use the formula '=A1/(B1*1440)'. (Results then would be, A1 = '40.00' (i.e. £40), B1= '1:30' (one and a half hours) C1 would then be '0.44' (i.e. 44p per minute). Bre90129th Jul 2005, 11:46MadsDad's suggestion is indeed quite right. :ok: For pedagogy's sake, I would just like to explain why : The unit time in Excel is the day (whichever format you use to display it), hence the 1440 factor = 24 hours x 60 minutes. Maxflyer29th Jul 2005, 12:24Thanks guys. Just the ticket. MF MadsDad29th Jul 2005, 12:37Bre I should have put some comment about the 1440, didn't think to. Also the fact that the 'hh:mm' restricts the time to hours and minutes. And, of course, if anyone wasnts to work out the cost/second the time format would need to be 'hh:mm:ss' (so now you've got seconds as well) and the multiplication would need to be (pause to use calculator) '*86400'. (And if you want it per day, leave off the '*1440').