convert formula to a number

Hi,
Please hel me edit the formula in colomn m, in such a way that instead of a result in time format it will be in number, i attached my template for your reference

Thanks

you may change the format of the cell to "General" and if this is not what you was looking for then provide with an example of what value you are looking for.

Quote:

---

Originally Posted by erpurohit

you may change the format of the cell to "General" and if this is not what you was looking for then provide with an example of what value you are looking for.

---

Have tried your that prior to posting this, but to no avail, please check my file,
Thanks
Ofel

what erpurohit said makes sense to me too, but apparently, that's not what you are looking for. Can you show with an example of what you need

I already attached my file, i got formula in column m, result is in time format , iwant that result to be in number format , tried to format that column using general, but not successful .



thanks

You just need to change the number format that's it. As i can see there is a custom format h:mm applied on the range just change it to general. Check attached file.

Attachment 1767