| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculateing
Hi, im having an absolute nightmare with this so any feedback would be fantastic I need to enter a formulae to calculate a column with hh:mm:ss (formatted for TIME) against a minute rate. So 00:00:30 at 20p a minute would be 10p - help! thnx -- n1kk1 ------------------------------------------------------------------------ n1kk1's Profile: http://www.excelforum.com/member.php...o&userid=35173 View this thread: http://www.excelforum.com/showthread...hreadid=549393 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
calculateing
Use =HOUR(B1)*60+MINUTE(B1)+SECOND(B1)/60 to convert the time to a number of
minutes that you can multiply with yor rate. HTH "n1kk1" wrote: Hi, im having an absolute nightmare with this so any feedback would be fantastic I need to enter a formulae to calculate a column with hh:mm:ss (formatted for TIME) against a minute rate. So 00:00:30 at 20p a minute would be 10p - help! thnx -- n1kk1 ------------------------------------------------------------------------ n1kk1's Profile: http://www.excelforum.com/member.php...o&userid=35173 View this thread: http://www.excelforum.com/showthread...hreadid=549393 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
