ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Adding numbers in a single cell (https://www.excelbanter.com/excel-worksheet-functions/45169-adding-numbers-single-cell.html)

chefcasey

Adding numbers in a single cell
 

I'm working on a work schedule. I would like to put two numbers that
represent time in a single cell and have them caculated.


Example:
A B C D E
F G H
1 Mon Tue Wed Thur Fri Sat
Sun
2
3 Robert 10-5 10-5 10-5 10-5 10-5 / /
4 Adam / / 3-10 3-10 3-11 3-12 3-9:30
5 Samuel 8;30-4 8:30-4 8:30-4 8:30-4 8:30-4 / /


Is this possible


--
chefcasey
------------------------------------------------------------------------
chefcasey's Profile: http://www.excelforum.com/member.php...o&userid=27198
View this thread: http://www.excelforum.com/showthread...hreadid=467169


Biff

See later post

Biff

"chefcasey" wrote
in message ...

I'm working on a work schedule. I would like to put two numbers that
represent time in a single cell and have them caculated.


Example:
A B C D E
F G H
1 Mon Tue Wed Thur Fri Sat
Sun
2
3 Robert 10-5 10-5 10-5 10-5 10-5 / /
4 Adam / / 3-10 3-10 3-11 3-12 3-9:30
5 Samuel 8;30-4 8:30-4 8:30-4 8:30-4 8:30-4 / /


Is this possible


--
chefcasey
------------------------------------------------------------------------
chefcasey's Profile:
http://www.excelforum.com/member.php...o&userid=27198
View this thread: http://www.excelforum.com/showthread...hreadid=467169





All times are GMT +1. The time now is 12:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com