Time calcualtion in minutes

J

Judy Gleeson

Excel 2007

Working with an .xls template used as a timesheet. Three columns time
started, time finished and time taken.

Can Time Taken be shown as minutes? We can subtract end from start time and
get to see it as hh:mm but can't get just mm as the correct total number of
minutes. eg if 9:30 to 11:00 is 1 1/5 hours, can we see a total as 90 minutes
somehow?




JudyG
 
B

Bernie Deitrick

Judy,

Format the cell as custom with the format

[mm]:ss

HTH,
Bernie
MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Rounding hh:mm to nearest 15, 30, 45 minutes 4
Subtracting time...again 2
Converting 1-60 minutes to quarter minutes in a formula 5
HELP! I need to make an IF Statement comparing date/time fields.. 2
Change time h:mm to a decimal number based on hours 6
adding rows of hours and minutes to get a total 1
Formula to find Stop Time from Start Time and Total Minutes 5
Figuring and adding time in Excel 2

Top