# Time (hh:mm) format

#### shanefowlkes

##### New Member
This is probably really simple but how can I format cells in Excel 2000 to store time as hours:minutes. I currently have them formatted as "Time" and the sample shows 13:30 but I think it's showing the time of day (ex 1:30pm) instead of hh:mm. I want to have a column that stores hh:mm and to be able to sum it at the bottom.

Thanks

### Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},\$Z\$1:\$Z\$99,\$Y\$1:\$Y\$99),2,False) to lookup Y values to left of Z values.
the format for elapsed time calculations is [hh]:mm

So why when I format a cell(s) with that (as Time and as Custom) does the formula bar show 1:30:00 AM for "1:30" AND when I sum up a column using this format, it doesn't work?

Thx

off hand - don't know! I am surprised that you're getting 01:30:00 AM !?! How are your time values being generated? As far as the sum is concerned, the format shouldn't make a difference to whether it 'works' or not, just to what results get displayed. Care to post a snapshot of your data using the html maker from the link below, or provide more info on the formula you're using?

Does this help?

In column F, I'm tracking hours and minutes spent on a given task. I want to sum it all up as needed. It's that simple.

Would it be easier just to record minutes (1.5 hours AKA 1:30 = 90 minutes) and just divide by 60 in my sum to get hours? If I do, what happens when have..say 100 minutes. It comes to 1.6666 hours. How can I figure the remaining minutes?

Thx.

I don't get it - the sum is correct - what's the problem?

Replies
4
Views
268
Replies
3
Views
323
Replies
10
Views
291
Replies
1
Views
578
Replies
3
Views
1K

1,218,746
Messages
6,144,264
Members
450,533
Latest member
xoxo1998

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back