Trying to Create a Excel Spreadsheet that will tabulate workout ti

G

Guest

I am trying to tabulate the time that i have spent working out and the way i
am trying to do it is not working. Excel is entering the the time ie 1 minute
40 seconds as a time 12:01.40 am. so when i try to sum the total time I am
getting a crazy Answer
 
G

Guest

I do not know if this will work for you but give it a try :
Under Format, Cell, click on the Number tab and select Time
When entering minutes and seconds they shoudl read 0:1:40 for 1 minute forty
seconds.

Good luck.
 
I

iliace

First of all, use the correct number format. You probably need
[h]:mm:ss, which will enable you to have a sum of over 24 hours. Go
to Format->Cells->Number->Custom, and paste that format code.

The "crazy" answer you're getting is Excel's internal representation
of the number. Again, using a time value number format fixes this
problem.
 

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

How can protect an Excel spreadsheet with a password 1
Trying to create a system image - VSS Backup error 0x807800A1 1
How can I make an Employment Schedule that Tabulates hours worked. 1
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Does anyone have a formula for SMPTE timecode in Excel? 1
calculating time, overtime in excel [h]:mm format 4
creating new microsoft office excel spreadsheet 4
How can I perform calculations in Excel using time? 2

Top