How to insert a column of times

Pages (2): 1 2 Next

11-01-2023, 08:41 PM

I have a spreadsheet with volunteer times in hr:min format. (1:30, 2:45, 0:30, etc). You want to know how to add a column of numbers, but the formula you tried doesn't work.

FuturzLeCanape

11-01-2023, 08:41 PM #1

I have a spreadsheet with volunteer times in hr:min format. (1:30, 2:45, 0:30, etc). You want to know how to add a column of numbers, but the formula you tried doesn't work.

Jithle
Junior Member

11-01-2023, 09:01 PM

Ensure the times are entered in a proper time format within cells. Your calculation might fail because they appear as text. If you move your cursor to a cell with "1:30", the formula bar displays "01:30:00 AM". This indicates Excel treats it as a time value instead of text.

Jithle

11-01-2023, 09:01 PM #2

LoveIsland
Junior Member

11-01-2023, 10:28 PM

The provided link leads to Microsoft support documentation regarding adding or subtracting time.

LoveIsland

11-01-2023, 10:28 PM #3

The provided link leads to Microsoft support documentation regarding adding or subtracting time.

catseecoo
Senior Member

662

11-01-2023, 11:34 PM

Ensure the times are entered in a proper time format. The sum might not function correctly if they appear as text. If you move your cursor to a cell with "1:30", the formula bar displays "01:30:00 AM" which indicates Excel treats it as a time.

catseecoo

11-01-2023, 11:34 PM #4

luukieluke21
Member

180

11-02-2023, 06:29 PM

Time
1:20
2:30
4:50
8:40
=SUM(E1:E6)

luukieluke21

11-02-2023, 06:29 PM #5

Time
1:20
2:30
4:50
8:40
=SUM(E1:E6)

ninou1998
Junior Member

11-03-2023, 01:50 AM

The data spans more than 24 hours and is stored as time values. The current approach isn't functioning. There might be hidden elements within the cells affecting the calculation.

ninou1998

11-03-2023, 01:50 AM #6

The data spans more than 24 hours and is stored as time values. The current approach isn't functioning. There might be hidden elements within the cells affecting the calculation.

KingJjpr
Member

214

11-04-2023, 10:50 PM

Sum(f3:f54)*24 gives the total in hours, ensuring the cell displays a number. Multiplying by 24 converts it to hours. I checked with 29 rows of 6:16 and obtained 181.73 hours. Do you require the result in hours and minutes or is decimal hours fine?

KingJjpr

11-04-2023, 10:50 PM #7

JGood456
Member

168

11-05-2023, 05:31 AM

Thank you. I believe you mean the final cell is set to display only numbers, while the rest show times.

JGood456

11-05-2023, 05:31 AM #8

Thank you. I believe you mean the final cell is set to display only numbers, while the rest show times.

DatcheG
Junior Member

11-05-2023, 12:53 PM

You can share a link to your Sheets spreadsheet by copying the URL from the sheet and pasting it here.

DatcheG

11-05-2023, 12:53 PM #9

You can share a link to your Sheets spreadsheet by copying the URL from the sheet and pasting it here.

KenDerGuru
Junior Member

11-05-2023, 07:14 PM

#10

Check this link: https://webapps.stackexchange.com/q...ti...just-minut

KenDerGuru

11-05-2023, 07:14 PM #10

Check this link: https://webapps.stackexchange.com/q...ti...just-minut

Pages (2): 1 2 Next