Converting total hours worked to decimal

Question

Start &amp; Finish times are shown as hours and minutes.Start time is in Col C3 and Finish time is in Col D3, so I need to show total hours worked in Decimal in Col E3. converted to Decimal .eg: Start time is 9:00 pm, Finish time is 7:00 am, so Total hours worked is 10 hours, which I want it to read 10.00 hours, not 10:00 hrs.&nbsp;

riny_van_eekelen · Answer

Monica_Craig&nbsp;That would be&nbsp;=MOD(D3-C3,1)*24and format the cell as Number.&nbsp;

monica_craig · Answer

Thanks Riny for your reply, but am I able to send you my spreadsheet, as I am still stumped with it.

riny_van_eekelen · Answer

Monica_Craig&nbsp;You can share it via Onedrive or something similar or send it to me via a direct message.

monica_craig · Answer

Thanks! By direct message, how does that work?

monica_craig · Answer

Or what is your email addy?

Forum Discussion

Converting total hours worked to decimal

Share

Resources