Formatting Matrix : display duration in the form of HH:MM

[bbkeithmak]

I have a matrix as below. The value in the matrix is minutes

	Day 1	Day 2	Day 3	Day 4	Day 5	Day 6
Total	75	125	70	75	100	30
Member 1	30	30	50	40	80	15
Member 2		45
Member 3	45	50		35
Member 4			20		20	15

I need to display the matrix with the following format HH:MM e.g. 01:15 means 1 hour 15 mins

	Day 1	Day 2	Day 3	Day 4	Day 5	Day 6
Total	01:15	02:05	01:10	01:15	01:40	00:30
Member 1	00:30	00:30	00:50	00:40	01:20	00:15
Member 2		00:45
Member 3	00:45	00:50		00:35
Member 4			00:20		00:20	00:15

Is this possible ?

Keith

[amitchandak]

@bbkeithmak , You can create a text of time measure

a new measure on existing meausre

= Time(0,0,0) +[Measure]/(60*24)

or

=  Quotient([Measure], 60) & ":" & Mod([Measure], 60)