Help needed in time formula

[raghavender]

Hi,

I have value in minutes, i.e.4:38 (This is an average time to complete a transaction).

I would like to calculate, in one hour how many transactions are possible to complete.

This is a simple calculation but unable to perform.

Please help.

Thanks,
Raghu

 

[VoG]

Perhaps like this

Excel Workbook
	A	B
1	00:04:38	12
Sheet8

 

[raghavender]

Also, when i copy this value 4:38 into excel , it is converting to date format, please advice how to change the cell format to hours, minutes and seconds.....

Thanks
Raghu

 

[VoG]

Click in the cell, press CTRL + 1, Click Time and select one of the Time formats.