I need to record minutes then calculate the totals on a daily basis. Using the normal number formats doesn't work, because 60 minutes is shown as 0.60, not 1.00. So, 40 plus 40 is calculated as 80 not 1.20. Using the date/time formats doesnt work either, because the system wants to show the date. Similarly Custom Format hh:mm doesn't work, because the resulting figures are shown as a date.
Can anyone please help?
Last edited by Luvchyle; 10-11-2010 at 04:28 PM.
You should be able to use time formats, use a colon to separate hours and minutes so 40 minutes is entered as 0:40.
You can then sum times, 0:40 and 0:40 added will give you 1:20 as required. Make sure result cell is formatted as [h]:mm (with square brackets) if the totals might be over 24 hours
Audere est facere
how do i enter 1 minute, 0:60 or 1:00
0:01 for 1 minute
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
ok it jus that 0:01 looks like 1 second, it just looks weird i guess
does it matter then that when i use the time format when i click on the cell i see the date in the tying box?
No, it shouldn't matter for your purposes.
You can ignore what's in the formula bar - that's dictated by your regional settings and can't be changed like a cell format - essentially they are two different ways of formatting the same data - the underlying value is what matters.
Note that if you enter data with a single colon that's always interpreted as hours and minutes, so 12:34 is 12 hours and 34 minutes. If you want 12 minutes 34 seconds you need to enter as 0:12:34
Ok thanks guys appreciate the help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks