Time format for workschedule

L

Lifeguard

Hi, I'm looking for some help
I'm looking to calculate timesheets, but instead of 2:15 in format of 2
hours 15 minutes, I'm looking to save as 2.25 where it's 2 hours and 0.25
hours
I would take calculations from Cell A1 as start time of 8:00 AM and Cell A2
end time of 10:15 AM and result in Cell A3.
any suggestions?
 
N

Nick Hodge

Lifegaurd

=(A2*24)-(A1*24)

formatted as 'general'

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 

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

Graph usage for times of day 0
Excel 2019 Chart Time Format 0
Correction: Excel 2010 Chart Time Format 0
Determine if night shift by start & end time 2
Calculate end date and time 1
ASK Field Formatting 1
Creating a dynamic chart range where the range to be graphed depends on the contents of a cell 0
Time within time 8

Top