Calculating daily hours (as text) in the weekly total formula

C

CNBCheryl

I am baffled as to how to get my spreadsheet to recognize the daily
totals and accumulate to equal weekly hours...
i.e. COLUMN 1: 7:45 AM COLUMN 2: 6:00 PM COLUMN 3 (SUM OF ROW 1 & 2)
AND IT PROGRESSES THROUGH THE WEEK, BUT WHEN I TRY TO GET MY TOTALS COLUMN TO
READ COLUMN 3.
 
D

David Biddulph

7:45 AM in A1, 6:00 PM in B1, =B1-A1 in C1 gives 10:15 if you format the
result as [h]:mm, and if you keep that format in column C you can total the
numbers for the week.
 

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

Formula for calculating target hours against actual hours 12
Calculate Total Hours when Overlapping Occurs 0
Calculate After hours 3
Arriving at totals 2
15 minute data to daily data 1
Calculate Daily Interest, Paid out Weekly 5
Excel: counting times and dates during non-traditional hours 0
Weekly Time Sheet Summary 2

Top