Hi

I want to display a time in HH:MM

I have Time(8,0,0) which returns 08:00

If i have TIME(72,0,0) it returns 00:00:00. I guess it is because I've gone over 24 hours i.e. one day. So how do I alter TIME(72,0,0) to return DD:hh:mm, can I have both formats in the same column?

Cheers

Jon