How do I convert a time format to a double

G

Guest

I use a function to calculate the hours worked based on time

12:00pm to 4:00pm is 4.0 hours

when I get the number for hours worked it is in time format / .27398237 I
need the number 4 so that I can do my calculation. How do I convert it to a
number?
 

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

Calcualte date and time 3
Calculating Working Hours, Days and Overtimes. 1
Time Sheets 2
#VALUE error add'g formulas 1
TIME CALCULATION 7
Time Format 7
Excel Excel IF variable based on time of day 0
Time Calculated minus breaks & lunch 2

Top