Calculate row values as in hours and minutes

[asyamonique]

Sun	Mon	Tue	Wed	Total Overtime
60	125	45	-75	155
-120	60	-60	-60	-175

<colgroup><col span="4"><col></colgroup><tbody>
</tbody>

Hi,
Could you please help me to calculate to minutes into hrs?
Given sample above from Row A1:D1=E1(in minutes)
Cell E1 total 155min. formula will show as "2hrs 35min"
Cell E2 total -175min. formula will show as "-2hrs 55min"
Many Thanks

 

[Jonmo1]

Try this

=IF(SUM(A1:D1)>=0,"","-")&TEXT(ABS(SUM(A1:D1)/1440),"h""hrs"" mm""min""")

However, this is not a 'real' time value. It's just a text string.
You won't be able to do any math with it.

I'd recommend a helper column to put the 'real' time value in, with just a simple sum in E1
=SUM(A1:D1)

Then in F1 put
=IF(E1>=0,"","-")&TEXT(ABS(E1/1440),"h""hrs"" mm""min""")