Calculating Time
I have a spreadsheet with 2 columns. The first column is the start time and
the second is the end time. They are shown in military time. I want to calculate the difference between the two so I can get hours worked but when the time overlaps days I get no result. For example if a worker started at 16:00 (4:00pm) and ended at 01:18 (1:18am) I get no result. Why is that? It seems to work on calculations that do not overlap into the next day. |
Calculating Time
Secret Squirrel"
For times that do or could cross midnight use: =Mod(C2-B2,1) or =C2-B2+(C2<B2) -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Secret Squirrel" wrote in message ... I have a spreadsheet with 2 columns. The first column is the start time and the second is the end time. They are shown in military time. I want to calculate the difference between the two so I can get hours worked but when the time overlaps days I get no result. For example if a worker started at 16:00 (4:00pm) and ended at 01:18 (1:18am) I get no result. Why is that? It seems to work on calculations that do not overlap into the next day. |
Calculating Time
Thank you very much Sandy!
"Sandy Mann" wrote: Secret Squirrel" For times that do or could cross midnight use: =Mod(C2-B2,1) or =C2-B2+(C2<B2) -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Secret Squirrel" wrote in message ... I have a spreadsheet with 2 columns. The first column is the start time and the second is the end time. They are shown in military time. I want to calculate the difference between the two so I can get hours worked but when the time overlaps days I get no result. For example if a worker started at 16:00 (4:00pm) and ended at 01:18 (1:18am) I get no result. Why is that? It seems to work on calculations that do not overlap into the next day. |
All times are GMT +1. The time now is 03:36 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com