convert formula to a number

[galang_ofel]

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

[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.

[galang_ofel]

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

[Excel Fox]

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

[galang_ofel]

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

[LalitPandey87]

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.

Man Hours Guard Template 1-1.xlsx