negative time beyond 24hrs

[SAsplin]

Hi,

I'm using the following formula on a spreadsheet to check how many flexi hours someone owes/ is owed:

=IF(E6<0,TEXT(E8/1440,"-H::MM"),TEXT(E8/1440,"H::MM"))

E6 contains a decimal value of the time, e.g. -2 and E8 contains a positive value of that time in minutes, e.g. 120.

This formula works fine until you go beyond 24 hours and then it counts from 1 again, i.e. if a person were to owe 1500 minutes the formula returns -1:00 instead of -25:00.

How can I fix this? I can't change the sheet to 1904 date format due to other processes.

Help!

SA

[Bob Phillips]

Try this

=IF(E6<0,"-","")&TEXT(ABS(E8)/1440,"[h]:mm")

[SAsplin]

Bob, that works a treat. Many thanks.