New User- Complex Excel for Mac 2008

Joined
Mar 6, 2011
Messages
1
Reaction score
0
Points
1
Sorry, not sure exactly where to post.

Bit of a complex problem, but comes down to needing to divide to elapsed times by each other, then multiplying by 100 to get (time/time)=(percentage)

I know that to do elapsed time to the correct accuracy I need (mm):ss.s but can't work out how to do (mm):ss.s divided by (mm):ss.s.

Note: All round brackets are square brackets

Can anyone help?
ws242
 

chscag

Well-known member
Staff member
Admin
Joined
Jan 23, 2008
Messages
65,248
Reaction score
1,833
Points
113
Location
Keller, Texas
Your Mac's Specs
2017 27" iMac, 10.5" iPad Pro, iPhone 8, iPhone 11, iPhone 12 Mini, Numerous iPods, Monterey
If no one has the answer for you here, I suggest going to the Mac Office forums on the MS server and ask there. The forum is open but you have to register first. Here is the LINK.
 
Joined
May 20, 2004
Messages
243
Reaction score
12
Points
18
Your Mac's Specs
iMac 21" 8GB, MBP 15" 2.5 Penryn, 4 GB/180 GB
Time in Excel is a serial number (days are whole numbers, hours/minutes/seconds are decimals).

See if this helps you to get started:

Calculate minutes

To get seconds, just multiply that by 60.
 

Shop Amazon


Shop for your Apple, Mac, iPhone and other computer products on Amazon.
We are a participant in the Amazon Services LLC Associates Program, an affiliate program designed to provide a means for us to earn fees by linking to Amazon and affiliated sites.
Top