Tally Chart

[Shakes007]

Hi,
I am doing some study work and would help to complete data. In Column A I have a formula to count the number of times completed said task. What the goal is, column 'B' to take the total completed tasks and convert that to time. For example, A1 displays 25 (each record is done in 30 mins) is there a formula to change that to display in B1 25*30 displayed in time spent not time of the day?
Kind Regards,

 

[Fluff]

Not sure if I'm missing something but why not just

=A1*30

or if you want it in hours

=A1*0.5

 

[jtakw]

Hi,

May be this:

Book3.xlsx
	A	B
1	25	12:30
2		^Custom Format
3		[h]:mm
Sheet911

Cell Formulas
Range	Formula
B1	B1	=(A1*30)/1440

 

[Shakes007]

Two great answers. Saved me so much time.
Thank you

 

[Fluff]

You're welcome & thanks for the feedback.