Fixing and Calculating Time

[MercyMercyMe]

Hello Good People.
I have a spreadsheet with the following data:

PROBLEM #1 = when clerk recorded duration, he did this: "4:32". He was recording mm:ss , Excel is reading as hh:mm. 2K entries in 20 files and report is due! The only way I could convert was to transfer times to Word, add "00:" in front, copy back to Excel. Is there faster way to make excel read minutes/seconds instead of hours/minutes?
PROBLEM #2 - i have multiple tasks, the time to complete needs to be summed.
How many minutes did this person spend Closing on this date?
How many minutes did this person spend on the phone on this date?


Task # Task Name/Cat Date Start Stop Duration
1 Closing 17-Apr 10:12 AM 10:14 AM 2:20
2 Phone 17-Apr 10:14 AM 10:14 AM 0:24
4 Closing 17-Apr 10:19 AM 10:46 AM 27:01

The Start and Stop Times are not accurate.
The Durations are accurate and I want to add up and make a pie chart. but I can't get excel to see the times correctly and calculate. Please help me!!!
I'm terrible with Pivots
THANK YOU SO MUCH.

[SlipEternal]

#1 divide by 60.
#2

Please Login or Register  to view this content.

[MercyMercyMe]

Thanks so much SlipEternal - -
I'm not familiar with the term 'table' in excel, but i get it.

I

[FDibbins]

Problem 1
Recalc the time.
Put this in a helper column, format as Custom mm:ss.0;@
copy down as needed.

Then use that helper column for your calcs

[MercyMercyMe]

Thank You - -

I'll have to look all of that up and try it but I will consider this issue closed unless something doesn't work.
Thanks for your help.

[MercyMercyMe]

What star? I only see the rating stars. Is that what you mean?

[FDibbins]

In the bottom-left corner of all posts is a star with "Add Reputation", Add Infraction" etc

[AliGW]

'Add Infraction' will not be visible - that's for moderators and administrators - but 'Add Reputation' and 'Report Post' will.

[MercyMercyMe]

Thanks FDibbins!

This is a lot of stuff to learn. I know nothing about Visual Basic except that I have maximum respect for those who do. I am not familiar with Helper columns either. BUT...I am researching and trying to figure it all out.
This is good stuff.
Thanks so much.

[MercyMercyMe]

Thanks Ali! I used "Add Reputation".

[AliGW]

Glad to help!

[FDibbins]

'Add Infraction' will not be visible - that's for moderators and administrators - but 'Add Reputation' and 'Report Post' will.

yup, wasnt thinking, thanks

Thanks for the feedback, Mercy